Dear forum members,
I'm a beginner user, and I was wondering if you could please help me solve this problem...?
I'm looking for a way/function to look up a specific word in a text column, and I want to be able to call that cell something else. For example, I'm trying to look up the word "*major*" in column 31 (AE) and row 50, and if that word appears in that row and column, I want the cell to appear as "Major Member." Any suggestions?
Thank you in advance for your suggestions.
Best regards,
Losamfr17
I'm a beginner user, and I was wondering if you could please help me solve this problem...?
I'm looking for a way/function to look up a specific word in a text column, and I want to be able to call that cell something else. For example, I'm trying to look up the word "*major*" in column 31 (AE) and row 50, and if that word appears in that row and column, I want the cell to appear as "Major Member." Any suggestions?
Thank you in advance for your suggestions.
Best regards,
Losamfr17