Vlookup with #N/A

S

sverre

How do I write a vlookup that works for n/a

IF(F45=--#N/A;1;0)

Above one does not work

br
sverre
 
S

sverre

Sorry, wrong of me....

Below does not work when there is na. Can I correct it?

=IF(--F8="#N/A";1;0)

f8 is by the way a Vlookup that has catched a number.

sverre
 
N

Niek Otten

Use the ISNA() function to test for #NA

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Sorry, wrong of me....
|
| Below does not work when there is na. Can I correct it?
|
| =IF(--F8="#N/A";1;0)
|
| f8 is by the way a Vlookup that has catched a number.
|
| sverre
|
| >
| > br
| > sverre
 
R

Ron Coderre

Try this:

=IF(ISNA(F8);1;0)
or
=--ISNA(F8)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top