Excel IF statement, true value equals value in another cell

In Excel I'm trying to make a IF statement that logically sounds like this: If a cell in this range contain "TS" Look up the value in the Same column in Row 4 and make it hat value.

Essentially : =IF(COUNTIF(AC5:BC5,"TS"),( the same column as the one that contains TS but the value Row 4,"")

enter image description here

Anyone have any ideas?