problem with ISNA and VLOOKUP

W

webstju

accidentally posted this in General

Need help with a formula..

Let's say I have "12/31/2000" in Sheet 1, Cell A1 and I need to see if
this date is in a table in Sheet 2 and if it is it will return a value
of "1" and if not it returns a value of "2"

The formula I have is

=IF(ISNA(VLOOKUP(A1,Sheet2!A1:B4,2)),0,1)


12/31/2000 is NOT located in Sheet 2 yet I still get a return value of
1.. help would be appreciated
 
B

Bob Phillips

It is doing an approximate match. Use

=IF(ISNA(VLOOKUP(A1,Sheet2!A1:B4,2,FALSE)),0,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

having trouble with ISNA and VLOOKUP 2
Two VLookups in one arguement 4
vlookup returning Errors (ISNA formula) 3
Vlookup and return sheet name also 2
ISNA Formula returning "False" instead of value 4
isna vlookup #n/a but not false 1
Help: vlookup from multiple sheets and spreadhseets 1
I need help with a IF(ISNA with vlookup 5

Top