Help using the IF and SEARCH functions, I hope this is simple for all of you!

[cmanlongat]

http://i63.tinypic.com/2ugz67m.png

Main objective is to list Column A5 (Shifts) with either Day, Swing, or Grave depending on the employees schedule listen vertically in column C5:I5.

Is there a formula that could offer me with the right results? I tried an IF(ISNUMBER(SEARCH("1P - 9P",C5) "Swing", ""))) type of formula but I had to do this for every single shift time.

If anyone can help me with this, I would really appreciate it. Also, the schedule format has to be in that same way in the example, I cannot change it.

 

[yky]

deleted

 

[Aladin Akyurek]

Try to repost your sample using: https://www.mrexcel.com/forum/about-board/508133-attachments.html