Forum Discussion

HMB1992's avatar
HMB1992
Copper Contributor
May 15, 2023

Vlookup not working, Tools n Price sheet

Hello Vlookup not working giving an error message. Find on the Tools n Price Sheet. Thank you.    also unable to attach the excel. Where can I find the attachment button
excel
HansVogelaar's avatar
HansVogelaar
MVP
May 15, 2023

HMB1992 

Thank you.

VLOOKUP always searches the first column of the lookup range.

The first column of the range named tools is column A, but the description you're looking for is in column B.

This will work:

=VLOOKUP(H2,$B$2:$E$56,4,FALSE)

The column index is now 4 instead of 5 since we start counting from column B.

  • HMB1992's avatar
    HMB1992
    Copper Contributor
    May 15, 2023
    Just to confirm, so what I'm looking for should always be the first column of the table inside the Vlookup formula, correct ?
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 15, 2023

      HMB1992 

      Yes, that is correct.

      An alternative would be a combination of INDEX and MATCH, or if you have Microsoft 365/Office 2021, the new function XLOOKUP 

Resources