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...
Excel 2016
- @yea-so Thank you for your work on this!
Mr_McSquirrelly since you already work with PowerQuery for the import of the "12 Games Table", why not use PQ also for what is does best. That is, clean-up messy data into something more useful. Rather, than trying to look up inconsistently used school names with formulae, make use of PQ's capability of fuzzy matching with the help of a transformation table. That way, you can merge the list of schools (A18:A23) with matching information from Table1. Just a suggestion.
- Yea_So, sorry! I should've clarified before what version I'm using. I will save your formula if I ever upgrade.
- we're going to have to re-work the formula since excel 2016 does not the spill feature, we're going to have to do the LEFT(), RIGHT() and MID()
