Looking up text string and creating your own expression

[losamfr17]

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

 

[losamfr17]

Yes, that's why I was lost. Again, thank you!

 

[63falcondude]

Glad to help!

 

[losamfr17]

FlaconDude,

Good morning.

Can I get your opinion on this matter please?
What language in a macro do you use to select any range of data set in order to turn that set into a table? For example, now I'm dealing with a worksheet with data entries ranging from A1:EL85. But what if the next spreadsheet I get has entries ranging from A1:FA102, my previous macro won't work.
Is one able to write a general command to create a table to apply to all sizes?

Thank you.