Hi there!
I am trying to create a formula to do a lookup if one of a certain value is inside a job title.
So for example the values are:
VP, CEO, CIO, CTO, CFO, EVP, Director, Manager etc.
If in the field {Job Title} one of these titles is in the name, I want to return the field "Interesting.
Now I made this:
IF(FIND(“IT”, {Job Title}), “Interesting”, “”) &
IF(FIND(“Innovation”, {Job Title}), “Interesting”, “”) &
IF(FIND(“AI”, {Job Title}), “Interesting”, “”) &
IF(FIND(“digital”, {Job Title}), “Interesting”, “”) &
IF(FIND(“data”, {Job Title}), “Interesting”, “”) &
IF(FIND(“transformation”, {Job Title}), “Interesting”, “”) &
IF(FIND(“information”, {Job Title}), “Interesting”, “”) &
IF(FIND(“CIO”, {Job Title}), “Interesting”, “”)
But this returns:
InterestingInterestingInteresting for a few records.
Any idea what would be the best formula for this?
We can also make it a lookup? Or an array?
Happy to hear your thoughts!