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
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