Returning Zero rather than #NA with VLOOKUP

[broncos347]

I have a VLOOKUP formula =VLOOKUP(D7,'Combined COWD'!$A$1:$I$414,7,FALSE) which obviously returns #NA when the answer is false.

Is there a way to have it return a ZERO rather than the #NA?

 

[Andrew Poulsom]

In Excel 2007 and above:

=IFERROR(VLOOKUP(D7,'Combined COWD'!$A$1:$I$414,7,FALSE),0)

 

[broncos347]

Excellent many thanks

 

[ArunS]

Hello,

I come to you with a query on how I can link 2 different IF functions. Below are the formulas, that I am trying to get into as one.

1. =IFERROR(IF((1-AP16/AC16)>0,(1-AP16/AC16),0),0)

2. =IFERROR(IF((AP16/AC16)>0,(AP16/AC16),0),0)

Can you please advise?

Best Regards,
ArunS

 

[Andrew Poulsom]

Is it?

=IFERROR(IF((1-AP16/AC16)>0,(1-AP16/AC16),AP16/AC16),0)