Forum Discussion

Mr_McSquirrelly's avatar
Mr_McSquirrelly
Copper Contributor
Oct 17, 2021
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
Formulas and Functions
  • Mr_McSquirrelly's avatar
    Mr_McSquirrelly
    Copper Contributor
    Oct 18, 2021

    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.

    • Yea_So's avatar
      Yea_So
      Bronze Contributor
      Oct 18, 2021

      Mr_McSquirrelly 

       

      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/

       

      • Mr_McSquirrelly's avatar
        Mr_McSquirrelly
        Copper Contributor
        Oct 18, 2021
        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.

Resources