Formulas #N/A

[Darin]

I often write formulas w/ various Vlookup's or Match commands and how do I
get an "IF" function to recognize #N/A . . basically I'm saying IF(Vlookup( .
.. . . )=N/A,0,Vlookup(. .. .. )). Basically I just want the formula to
recognize the #N/A as it would save me some time. Thanks for your help!

Darin

 

[Niek Otten]

Hi Darin,

=IF(ISNA(YourFormula),0,YourFormula)

 

[Ted M H]

If you're using Excel 2007 you can use the new IFERROR function. That way
you only enter your vlookup function and arguments once.

 

[Darin]

So this is where I end up:

=IF(ISNA(VLOOKUP(B722,'Nov 08'!$D$2:$F$800,3,FALSE),0,(VLOOKUP(B722,'Nov
08'!$D$2:$F$800,3,FALSE))))

It doesn't seem to like the 0 in the middle it keeps going back to that as
the error. I dumbed it down w/ out a Vlookup and I could get it to go but
the Vlookup seems to be throwing it . . thoughts?

 

[Pete_UK]

You have your brackets in the wrong place. Try it like this:

=IF(ISNA(VLOOKUP(B722,'Nov 08'!$D$2:$F$800,3,FALSE)),0,VLOOKUP
(B722,'Nov 08'!$D$2:$F$800,3,FALSE))

Hope this helps.

Pete