 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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