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
Microsoft Excel

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
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
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
mikes6058

ASKER
Both do the job perfectly

Thanks
Mike
Subodh Tiwari (Neeraj)

You're welcome Mike! Glad to help.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck