Formulas #N/A
 

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

Formulas #N/A
 

Hi Darin,

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darin" wrote in message
...
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

Formulas #N/A
 

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" wrote:

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

Formulas #N/A
 

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?

"Niek Otten" wrote:

Hi Darin,

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darin" wrote in message
...
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

Formulas #N/A
 

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

On Dec 6, 12:15*am, Darin wrote:
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? *



"Niek Otten" wrote:
Hi Darin,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darin" wrote in message
...
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- Hide quoted text -

- Show quoted text -