EEuser5551212
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER