Add Text if Letters Found

[The Animal]

Hi
A little question
I want a formula to populate as per below in the "M" column cell if the letter is part of the text in the "J" column cell.
If S found - Salary
If C found Casual
If PT found - Part Time

Any help would be great

Thanks Stephen

 

[Eric W]

Try:

=IFERROR(LOOKUP(2^16,SEARCH({"S","C","PT"},J2),{"Salary","Casual","Part Time"}),"")

 

[The Animal]

Thanks so much Brilliant

 

[ask2tsp]

try this

Excel Workbook
	J	K	L	M
2	very c			Casual
3	no s			Salary
4	pt only			Part time
5	what?
Sheet

 

[jtakw]

Hi,

Just curious, would there be instances where more than 1 of S, C, or PT be in the cells at the same time, like: Seasonal PT Worker, PT Cashier, etc.?

 

[The Animal]

Hi
No only S or C or PT
Thanks