I require assistance in a if (or any function). I have a report with different email domains but have a different name in the company columns
I want a formula
I tried with if and replace but didnt work
Thanks for the help
CT
Sender_Email | COMPANY_NAME | Final |
ABC@ABC.com | ABC | |
BCA@service.com | BCA | |
XYZ@data.com | BCA |
- where if the company in column "Company Name" is ABC then it should remain as ABC in column "Final "
- where the company in column "Company Name" is BCA then check column "Sender_Email.....check the domain name and update the column "Final" as "Service" (if the domain is service.com) and "Data" (if the domain is data.com)
I tried with if and replace but didnt work
Thanks for the help
CT