Forum menu
Topic starter
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!
Posted : 11/01/2012 11:49 am
Vlookup is what you need, I reckon.
Posted : 11/01/2012 11:51 am
Or, actually, if it's in columns, Hlookup...
Posted : 11/01/2012 11:52 am
or Match and Index together
Posted : 11/01/2012 12:17 pm
Topic starter
Match and Index seems to do it for me, cheers reggiegasket!
Posted : 11/01/2012 12:24 pm