Eliminating #N/A

M

Mike

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?
 
D

Duke Carey

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