Eliminating #N/A

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 14 Dec 2005 17:37 GMT

I have a formula that looks as follows:

=VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)

There are some values in Column A that are not in the Table Array contained
in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula
produces the #N/A.

In the event that the result of the VLOOKUP would be #N/A, I would rather
have the results be 0. Is there a way to modify the VLOOKUP formula to give
that result?

Reply to this Message

Niek Otten - 14 Dec 2005 17:43 GMT

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

Signature

Kind regards,

Niek Otten

>I have a formula that looks as follows:
>
[quoted text clipped - 9 lines]
> give
> that result?

Reply to this Message

Mike - 14 Dec 2005 19:34 GMT

Thank you

> =IF(ISNA(YourFormula),0,YourFormula)
>
[quoted text clipped - 11 lines]
> > give
> > that result?

Reply to this Message

Duke Carey - 14 Dec 2005 18:12 GMT

=IF(ISNA(VLOOKUP(A70,'Staffing
Assumptions'!$A$64:$D$75,4,FALSE)),0,VLOOKUP(A70,'Staffing
Assumptions'!$A$64:$D$75,4,FALSE))

> I have a formula that looks as follows:
>
[quoted text clipped - 7 lines]
> have the results be 0. Is there a way to modify the VLOOKUP formula to give
> that result?

Reply to this Message