Forum Discussion
Solved
Vlookup errors with parenthetic numbers
I am trying to make Vlookup find values from a table when values are listed by different names. When I download data from web, my lookup value comes into spreadsheet as (14) Miami (FL), or (10) Texas...
Mr_McSquirrelly I'd suggest you add a column with the "web based names" to your table and perform the VLOOKUP on that column.
Riny_van_Eekelen, I tried that, but the problem is the number in parentheses, such as (14) Miami (FL). It's a dynamic data range, so currently the team is listed as Miami (FL) because their rank has changed.
Mr_McSquirrelly But that shouldn't be too difficult to handle. But perhaps I underestimate the problem.
Riny_van_Eekelen Mr_McSquirrelly
I tried pq against the list in:
https://www.sports-reference.com/cfb/schools/
it does not include the actual team name, where referred name in one column and actual team name in another column
Have to manually click on Alabama for example to get
so it cannot be down using power query, I tried unless Mr_McSquirrelly has a direct link to a table I described above.
cheers