Hi All - I have a nested IF statement that only partially works.
<colgroup><col width="114"></colgroup><tbody>
</tbody>
This formula works when L3 = "B&H Foto and Electronics",
it works when L3 is not found in 'Special Accounts'!A:A,
but it does not work when L3 is found in 'Special Accounts'!A:A.
When L3 is found in 'Special Accounts'!A:A, it should give me the value in cell AY3 but instead it is giving me the value in cell AV3.
I've tried other variations but each time only 2 out of the 3 conditions work:
<colgroup><col></colgroup><tbody>
</tbody>Sorry if this is written in a confusing way. Would someone be able to help me with this please?
Thank you!
IF('20160229 ESD POS Import'!L3="B&H Foto and Electronics","005D0000003916X", IF('20160229 ESD POS Import'!L3='Special Accounts'!A:A,AY3,IF(L3<>'Special Accounts'!A:A,AV3))) |
<colgroup><col width="114"></colgroup><tbody>
</tbody>
This formula works when L3 = "B&H Foto and Electronics",
it works when L3 is not found in 'Special Accounts'!A:A,
but it does not work when L3 is found in 'Special Accounts'!A:A.
When L3 is found in 'Special Accounts'!A:A, it should give me the value in cell AY3 but instead it is giving me the value in cell AV3.
I've tried other variations but each time only 2 out of the 3 conditions work:
|
|
|
<colgroup><col></colgroup><tbody>
</tbody>
Thank you!