Help with Lookup formula

adnansajid33

New member
Joined
Jul 23, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Office 365
Hi all,

I am new to excel and learning on how to create a formula that would allow me to:

1. Look up Column AC1
2. If Column AC1 has the following peoples name: Ajay Devgan, Tom Cruise, John Smith
3. Then Return FDI on Column H
4. ELSE return whatever the existing value is for Column AC1

Thank you for your help
 
In H2

Code:
=IF(ISNUMBER(MATCH(ACI2,{"Ajay Devgan";"Tom Cruise";"John Smith"},0)),FDI2,ACI2)
 
Back
Top