#num

P

Pammy

I have a formula to give a 0 instead of an error. Some of the calculations
give me a #num instead of a 0, . Is there something I could add to the
formula below to either give a 0 or blank but no #num.


IF(ISNA(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y192,longv,2,FALSE))
 
M

Michael

Use iserror instead of ISNA
IF(ISERROR(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y192,longv,2,FALSE))
 
P

porter444

Try this instead:

=IF(ISERROR(VLOOKUP(Y192,longv,2,FALSE),"0",VLOOKUP(Y192,longv,2,FALSE)
 

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

Word macro that can call cells out of Excel for a find and replace 0
V Lookup multiple entires 1
IF Statement on multiple levels 6
Use a variable in a ShapeRange.Increment 0
Countdown macro - display settings 2
Mail Merge Switch - Dollars to Words 0
#num fix 1
Newbie Help - IF Yes No Function 0

Top