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
JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 12, 2023
Depends. Are you absolutely positive those 4 matches are identical? Perhaps you can attach an Excel file which contains only those four entries and the vlookup formula you are using?
DeonvZ's avatar
DeonvZ
Copper Contributor
Jan 13, 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.

Resources