Hi everyone,
I got lost trying to do a formula... Hope you can help me!
I have 3 worksheets:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Conditions for formula
If vendor in WS1 is not in WS2 nor WS3, then return blank ""
If vendor in WS1 has N/A expiry date, then return blank ""
if vendor in WS1 is in WS2 OR WS3, then return text "request form" ONLY IF the expiry date is < 31/12/2018
Thx!
Helena
I got lost trying to do a formula... Hope you can help me!
I have 3 worksheets:
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Conditions for formula
If vendor in WS1 is not in WS2 nor WS3, then return blank ""
If vendor in WS1 has N/A expiry date, then return blank ""
if vendor in WS1 is in WS2 OR WS3, then return text "request form" ONLY IF the expiry date is < 31/12/2018
Thx!
Helena