Forum Discussion

DeonvZ's avatar
DeonvZ
Copper Contributor
Jan 12, 2023
Solved

Vlookup not selecting first cell from top.

Hi,   I have a table with more than one match for the Lookup_value.  If there are four matches, then the result returned is from the last match found and not the first.  I've solved this be sorting...
Formulas and Functions
DeonvZ's avatar
DeonvZ
Copper Contributor
Jan 12, 2023

JKPieterse 

 

Thanks for responding.  The matches are identical.

 

I've done a spreadsheet demonstrating the issue.  I must be stupid, but I cannot find a place where I can attached the file.  Perhaps you ca send me your email address.

 

Best Regards

Deon 

HansVogelaar's avatar
HansVogelaar
MVP
Jan 13, 2023

DeonvZ 

If you cannot attach a workbook, you can make it available through OneDrive, Google Drive, Dropbox or similar - obtain a link to the uploaded file and paste the link into a reply.

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jan 16, 2023
      I think this is simply how VLOOKUP works and has always worked. With Excel 2010 I get identical results on your sample file. If you want to control the search direction, consider the XLOOKUP function, which has a separate argument to control this.