Formulas #N/A

  • Thread starter Thread starter Darin
  • Start date Start date
D

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
 
If you're using Excel 2007 you can use the new IFERROR function. That way
you only enter your vlookup function and arguments once.
 
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?
 
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
 
Back
Top