vlookup problem

Windows XP SP3, Excel 2K SP3, Excel newbie.

Please see the attached Excel file for a problem I am having with VLOOKUP.

Maybe I'm not understanding VLOOKUP properly:  Look at Sheet1! cell B3.  It contains a VLOOKUP formula.

Since the value of A3 does not occur in the lookup table, I was expecting (and hoping) that B3 would return "FALSE" or "N/A" or leave the cell blank.  Instead, it returns "2".  Why?
Example1220.xls
EEuser5551212Asked:
Who is Participating?
 
wabashbdwCommented:
Because VLOOKUP acts kind of like The Price is Right (closest without going over) unless you tell it otherwise.  Use this formula:
"=VLOOKUP(A3,Sheet2!$A$1:$B$5,2,FALSE)"

It will return "#N/A" if it doesn't find a match.
0
 
EEuser5551212Author Commented:
Great explanation.  Thanks!
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.

All Courses

From novice to tech pro — start learning today.