• 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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