having trouble with ISNA and VLOOKUP

[webstju]

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

[Niek Otten]

You need

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

See HELP or the function wizard for the 4th argument of VLOOKUP
--
Kind regards,

Niek Otten

"webstju" <[email protected]> wrote in message
news:[email protected]...
|
| 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
|
|
| --
| webstju
| ------------------------------------------------------------------------
| webstju's Profile: http://www.excelforum.com/member.php...o&userid=33703
| View this thread: http://www.excelforum.com/showthread...hreadid=536446
|

[Bob Phillips]

see response in worksheet.functions

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"webstju" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> webstju
> ------------------------------------------------------------------------
> webstju's Profile:
http://www.excelforum.com/member.php...o&userid=33703
> View this thread: http://www.excelforum.com/showthread...hreadid=536446
>