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...
Yea_So That's the URL https://www.sports-reference.com/cfb/schools/miami-fl/2021-schedule.html
But I use Query to bring the entire table into the workbook. I've attached the sheet again with the table that comes down through query.
Created KeyPhrase table, added column for Official Name in Website
Formula:
=IFERROR(VLOOKUP(FILTER(Table1[Official Name in Website],ISNUMBER(FIND(FILTER(KeyPhrases,ISNUMBER(FIND(KeyPhrases,A18))),Table1[Official Name in Website]))),Table1[#All],3,0),"")
The link where I got the Official Name in Website:
https://www.sports-reference.com/cfb/schools/
- That looks great! I tried using that formula to look up the next adjacent cell D8 by changing 3 to 4. But it did not find the value.
It works, I changed the 3 to reference cell D18, so any value i put in D18 will be the column it will look at:
that's column 4
column 5
column 6
column 7
column 8
Here's a refreshed file with 2 other variant formulas:
Take your pick
try testing it again
- I'm sorry. I wasn't clear. With your original formula you were able to find the value of C8 and put that value in B18. That's exactly what I was hoping to accomplish. However, I also need the value of D8 to be put in C18, so that B18 and C18 have the value of C8 and D8. I tried adjusting your formula by changing 3 to 4 at the end, hoping the formula would find the value in the fourth column of the table, cell D8.