Lookup Function

[Andrew]

I need to write a function that will do the following:

Look at cell A1 in sheet 1
See if it's in a range from A1:B30 in sheet 3
Return either True or False

I've tried the Vlookup and the Lookup functions but they
just return the nearest value. Can someone help me out?

Thanks,

Andrew

 

[Niek Otten]

Hi Andrew,

Use Vlookup. You probably omitted the fourth argument; it defaults to TRUE;
set it to FALSE. This will cause Excel to find an exact match instead of the
nearest.
So your formula would result in something like

=IF(ISNA(VLOOKUP(B1,A1:A4,1,FALSE)),FALSE(),TRUE())

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel