When lookup just won't do . . .

J

Jennifer

Hey guys,
What would you suggest I do in a situation where I want to see if a bank
check has cashed from a list in a spreadsheet. If you use lookup or vlookup
it just returns the value of the above cell if it doesn't find the correct
check. I'm sure this is a very easy answer, just has me stumped at the
moment. Thank you!
 
N

Niek Otten

Hi Jennifer,

The last (fourth) argument of VLOOKUP, which you probably omitted, should be
FALSE.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top