Eliminating #N/A
Thanks
"Duke Carey" wrote:
=IF(ISNA(VLOOKUP(A70,'Staffing
Assumptions'!$A$64:$D$75,4,FALSE)),0,VLOOKUP(A70,' Staffing
Assumptions'!$A$64:$D$75,4,FALSE))
"Mike" wrote:
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?
|