I’m sure there is an excel function to do the following but I’m not sure which one.
I’m trying to find the first instance of a text in a row of cells ( from left to right ) and return value of the column header of the column that that the text appears in to another cell.
If its not clear what I’m trying to do I can come up with an example, any help greatly appreciated!

Vlookup is what you need, I reckon.

Or, actually, if it’s in columns, Hlookup…

or Match and Index together

Match and Index seems to do it for me, cheers reggiegasket!