MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel
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 10:49 am
Vlookup is what you need, I reckon.
Posted : 11/01/2012 10:51 am
Or, actually, if it's in columns, Hlookup...
Posted : 11/01/2012 10:52 am
or Match and Index together
Posted : 11/01/2012 11:17 am
Topic starter
Match and Index seems to do it for me, cheers reggiegasket!
Posted : 11/01/2012 11:24 am
