software

Good afternoon,

In A5, I have the following formula:

=IF(ISNA(VLOOKUP($C10,vac_calc,2,FALSE)),quot;Not in
listquot;,VLOOKUP($C10,vac_calc,2,FALSE))I need to insert a new condition within this condition: I need to test the
value of a cell located in B5.

if B5=quot;Nquot; then do IF(ISNA(VLOOKUP($C10,vac_calc,2,FALSE)),quot;Not in
listquot;,VLOOKUP($C10,vac_calc,2,FALSE))

if B5=quot;Rquot; then do VLOOKUP($C10,vac_calc,7,FALSE)

How do I modify the formula in A5?

Thanks for your help

M.
One way, you can replace the 2 with

IF(B5=quot;Nquot;,2,IF(B5=quot;Rquot;,7))

If B5 is neither you could add a third option (I used 1).
IF(B5=quot;Nquot;,2,IF(B5=quot;Rquot;,7,1))quot;MIchel Khennafiquot; wrote:

gt; Good afternoon,
gt;
gt; In A5, I have the following formula:
gt;
gt; =IF(ISNA(VLOOKUP($C10,vac_calc,2,FALSE)),quot;Not in
gt; listquot;,VLOOKUP($C10,vac_calc,2,FALSE))
gt;
gt;
gt; I need to insert a new condition within this condition: I need to test the
gt; value of a cell located in B5.
gt;
gt; if B5=quot;Nquot; then do IF(ISNA(VLOOKUP($C10,vac_calc,2,FALSE)),quot;Not in
gt; listquot;,VLOOKUP($C10,vac_calc,2,FALSE))
gt;
gt; if B5=quot;Rquot; then do VLOOKUP($C10,vac_calc,7,FALSE)
gt;
gt; How do I modify the formula in A5?
gt;
gt; Thanks for your help
gt;
gt; M.
gt;
gt;
gt;