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?