Improve company productivity with a Business Account.Sign Up

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

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
Asked:
iarkowski
  • 2
1 Solution
 
byundtCommented:
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
 
iarkowskiAuthor Commented:
Superb!!!!!
0
 
byundtCommented:
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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