mikes6058
asked on
combining IF statement with Vlookup
I would like a formula to do the following;
Formula to feature in cell G2
IF cell E2 contains either of these three values, Pending, Awaiting supplier confirmation, SBA sent | Awaiting return, then return an email address found in the range K2:L35.
The email address must correspond to the name found in cell A2. If no value is present in A2 then return a blank.
If cell E2 contains any value other than the three stated above then also return a blank
This formula will be copied down for each row
Thanks Mike
combining-IF-Statements-with-vlookup.ods
Formula to feature in cell G2
IF cell E2 contains either of these three values, Pending, Awaiting supplier confirmation, SBA sent | Awaiting return, then return an email address found in the range K2:L35.
The email address must correspond to the name found in cell A2. If no value is present in A2 then return a blank.
If cell E2 contains any value other than the three stated above then also return a blank
This formula will be copied down for each row
Thanks Mike
combining-IF-Statements-with-vlookup.ods
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both do the job perfectly
Thanks
Mike
Thanks
Mike
You're welcome Mike! Glad to help.
pls try
Open in new window
Regards