Please see my public spreadsheet here:
My goal is to get the Location Code from tab 1 into tab 2 (tab 2 is a subset of specific zip codes and I need them with their matching Location Codes alongside them).
I was attempting to use a VLOOKUP to do it, but got this error:
Error: Did not find value '30096' in VLOOKUP evaluation.
In this case, I would expect to see the Location Code 79459 in this cell.
Guess I'm misunderstanding how VLOOKUP works and/or how to use it. I tried to follow the prompts.
Best Answer
It's not so much an error as a statement of fact. 30096 does not exist in column A which is where you are looking for it. The way vlookup works is the column you are looking for a match is always to the left. The index is the column you want to return when it finds a match.