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