Could it be that the VLOOKUP is looking for the true/false argument at the end when you are not using the formula wizard? I think if you use the wizard then it defaults to false, but maybe it's not smart enough to do that when you just type it in without the wizard?
Likely more possible if that is an older version of a spreadsheet being used in an updated version of excel.
__________________
Much like a sports ticker, you may feel obligated to read this
|