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

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

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

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

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 -