x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 333

Vlookup

I can NEVER get VLOOKUP to work, but my colleague has no issue.  Please see attached file and advise what the heck I am doing wrong.

Thanks.
VLOOKUP.xlsx
0
iarkowski
• 2
1 Solution

Commented:
VLOOKUP wants to find the lookup value in the first column of the lookup table. That would be column B on worksheet Test, suggesting a formula like:
=VLOOKUP(B2,Test!B\$2:E\$62,4,FALSE)
0

Author Commented:
Superb!!!!!
0

Commented:
Breaking the VLOOKUP formula apart:
=VLOOKUP(B2,Test!B\$2:E\$62,4,FALSE)
Look for the value in B2 in the leftmost column of the lookup table.
The lookup table is in Test!B\$2:E\$62.
The 4 means you want a value from the fourth column of the lookup table (column E).
The FALSE means that the leftmost column in the lookup table hasn't been sorted. Furthermore, you need an exact match for the value in B2.

If VLOOKUP can't find B2 in the leftmost column of the lookup table, it returns the #N/A! error value. In your original formula, you were looking for B2 in Test column A. It's not there, so VLOOKUP dutifully returned #N/A! as the result.

Another common reason for VLOOKUP failing to return a value would be if B2 is text that looks like a number and Test column B contains numbers. VLOOKUP won't find "5" if Test column B contains 5. The converse is also true.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Featured Post

• 2
Tackle projects and never again get stuck behind a technical roadblock.