Forum Discussion
Mr_McSquirrelly
Oct 17, 2021Copper Contributor
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...
- Oct 18, 2021
Donald_Genes
Oct 30, 2021Brass Contributor
Mr_McSquirrelly DOne! VLOOKUP(MID(A18,6,5),LEFT(Table1,5),2,0)