Replacing #N/A

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
 

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

VLOOKUP returning #N/A result 2
Set add function ignore #N/A 1
#N/A 5
Replace #N/A with 0 1
Formula returns #N/A 1
#N/A Conditional Formatting affects all cells? 9
Looking up a returned value defining a named range 2
VLOOKUP - 0 instead of # N/A 8

Top