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