View Single Post
Old 07-20-2016, 02:14 PM   #19
mrkajz44
First Line Centre
 
mrkajz44's Avatar
 
Join Date: Oct 2010
Location: Deep South
Exp:
Default

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
mrkajz44 is offline   Reply With Quote