find the TEXT in a range of cells

[trosasco23]

I have a report where I need to find the TEXT listed in a range of cells where most cells have numbers. Here is an example of what I need. I highlighted it on right in red.

[queuesef]

Control F (find command).

[trosasco23]

No, I'm sorry but that's not what I need. I need the formula to find the word on every row.. It wont be the same TEXT every time. its not specific and it wont necessarily be always in the same spot either. Sometimes it will be on a different day.

Maybe I can explain this better...

I have a list from C2-P2 - most of this row has numbers but there will be text in the same row - I just need a formula to find out what that text is. In this row C = It should be "LH"
The next row should be SH, and the one after should be MC...and so on. Hope my explanation helps.

thank you so much.

[XOR LX]

Hi,

=LOOKUP("Ω",C2:P2)

Regards

[trosasco23]

Well, I've never seen that little symbol before but thanks. That works

[XOR LX]

Then study some Greek!

And you're welcome!

Cheers