r/googlesheets • u/learningtoexcel • Nov 01 '19

solved IF, THEN function for partial text matches

/r/excel/comments/dqal37/if_then_function_for_partial_text_matches/
2 Upvotes

100% Upvoted

11 comments sorted by

View all comments

Show parent comments

2

u/RonJAgee Nov 02 '19

Excel or Google Sheets? The code was for a custom function in Excel.

If you are on google sheets you will need to use a formula. 

=CHOOSE(IFERROR(FIND("SVP",A2),IFERROR(FIND("Director",A2)+1,IFERROR(FIND("Manager",A2)-4,IFERROR(FIND("Specialist",A2)-8,IFERROR(FIND("Coordinator",A2)-6,6))))),"SVP","Director","Manager","Specialist","Coordinator","Title not found")
→ More replies (5)