Link to home
Start Free TrialLog in
Avatar of mikes6058
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
Avatar of Rgonzo1971
Rgonzo1971

Hi,

pls try

=IF(OR(E2="Pending",E2="Awaiting supplier confirmation",E2="SBA sent | Awaiting return"),VLOOKUP(A2,$K$2:$L$35,2),"")

Open in new window

Regards
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mikes6058

ASKER

Both do the job perfectly

Thanks
Mike
You're welcome Mike! Glad to help.