Vlookup with #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Above one does not work

br
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
 
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
 
Try this:

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

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

XL2002, WinXP
 
You must log in or register to reply here.

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

Help With VLOOKUP 2
#N/A result because data is on another worksheet 8
Vlookups to return a N/A value 3
VLOOKUP and #N/A 2
Set add function ignore #N/A 1
Use & with two formulas 2
Vlookup and If statement help 1
VLOOKUP results in problems in comparing 3

Back
Top