vlookup with wildcards

[freakofnature]

can't get "*"& cell ref wildcard to work, trying to vlookup in ref to a column of nfl teams 2-3 character abbreviations,
GB vlookup formula
DAL vlookup formula @SEA
and so on ... looking into another sheet that has all teams
with their fantasy points allowed by position in columns..


Team name QB pts RB pts WR pts K pts Total pts
GB 13 14 17 7 sum
DAL 12 12 15 8 sum
.. etc
the @ is what's hanging me up, it won't match @SEA to SEA

 

[freakofnature]

so, if there is no @ in the cell, does the function just go on as normal, as if there is no @

 

[AhoyNC]

Yes, see example below of SUBSTITUTE function. Cell A2 doesn't have an @, so function just returns whats in A2.

Excel Workbook
	A	B
1	@SEA	SEA
2	GB	GB
Sheet