Replacing #N/A

  • Thread starter Thread starter Bush Kangaroo
  • Start date Start date
B

Bush Kangaroo

I have a vlookup formula which returns a #N/A for some cells I a
wondering if I can add a formula ontop of my vlooku
................... if #N/A is returned then replace with "0
 
Try this formula:

IF(ISNA(vlookup formula), "0", vlookupformula)

regards,
Hans
 
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

Replace #N/A with 0 1
Set add function ignore #N/A 1
VLOOKUP returning #N/A result 2
Formula returns #N/A 1
Looking up a returned value defining a named range 2
#N/A error 4
#N/A 5
Formulas #N/A 4

Back
Top