software

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?
=IF(ISNA(YourFormula),0,YourFormula)

--
Kind regards,

Niek Otten

quot;Mikequot; gt; wrote in message
...
gt;I have a formula that looks as follows:
gt;
gt; =VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)
gt;
gt; There are some values in Column A that are not in the Table Array
gt; contained
gt; in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula
gt; produces the #N/A.
gt;
gt; In the event that the result of the VLOOKUP would be #N/A, I would rather
gt; have the results be 0. Is there a way to modify the VLOOKUP formula to
gt; give
gt; that result?
gt;
gt;
Thanks

quot;Duke Careyquot; wrote:

gt; =IF(ISNA(VLOOKUP(A70,'Staffing
gt; Assumptions'!$A$64:$D$75,4,FALSE)),0,VLOOKUP(A70,' Staffing
gt; Assumptions'!$A$64:$D$75,4,FALSE))
gt;
gt;
gt; quot;Mikequot; wrote:
gt;
gt; gt; I have a formula that looks as follows:
gt; gt;
gt; gt; =VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)
gt; gt;
gt; gt; There are some values in Column A that are not in the Table Array contained
gt; gt; in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula
gt; gt; produces the #N/A.
gt; gt;
gt; gt; In the event that the result of the VLOOKUP would be #N/A, I would rather
gt; gt; have the results be 0. Is there a way to modify the VLOOKUP formula to give
gt; gt; that result?
gt; gt;
gt; gt;

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

gt; I have a formula that looks as follows:
gt;
gt; =VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)
gt;
gt; There are some values in Column A that are not in the Table Array contained
gt; in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula
gt; produces the #N/A.
gt;
gt; In the event that the result of the VLOOKUP would be #N/A, I would rather
gt; have the results be 0. Is there a way to modify the VLOOKUP formula to give
gt; that result?
gt;
gt;

Thank you

quot;Niek Ottenquot; wrote:

gt; =IF(ISNA(YourFormula),0,YourFormula)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Mikequot; gt; wrote in message
gt; ...
gt; gt;I have a formula that looks as follows:
gt; gt;
gt; gt; =VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)
gt; gt;
gt; gt; There are some values in Column A that are not in the Table Array
gt; gt; contained
gt; gt; in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula
gt; gt; produces the #N/A.
gt; gt;
gt; gt; In the event that the result of the VLOOKUP would be #N/A, I would rather
gt; gt; have the results be 0. Is there a way to modify the VLOOKUP formula to
gt; gt; give
gt; gt; that result?
gt; gt;
gt; gt;
gt;
gt;
gt;