Forum Discussion

Paul00's avatar
Paul00
Copper Contributor
Apr 23, 2024
Solved

vlookup

I downloaded some results from the Masters Golf Tournament and would like to use vlookup to populate a spreadsheet with only select golfers. I've reduced the leaderboard to save space.

The formula in cell L2 is =VLOOKUP($K2,$B$1:$H$10,3,TRUE), formula in cell M2 is =VLOOKUP($K2,$B$1:$H$10,4,TRUE), etc.

 

The result for the formula in cell L2 should lookup K2 (Scottie), find him in the range $B$1 and return column 3 which is 66. The results are coming from the last row for Cameron Young.

 

I can't figure what I am doing wrong.

 

 

 

  • Paul00's avatar
    Paul00
    Apr 24, 2024

    HansVogelaar 

     

    Thanks, that certainly explains it. In my case the use of wildcard characters helps.

5 Replies

    • Paul00's avatar
      Paul00
      Copper Contributor

      HansVogelaar 

       

      That definitely works, but I am wondering what the TRUE parameter is good for? I was hoping to enter a list of golfers without the country they are from. When I download the leaderboard table from the website there are small country flags depicting where the golfer is from. When copied to an Excel spreadsheet the flags become the country in text.

       

Resources