Column name look up

**Cameran** · 02-29-2012, 03:26 PM

Hi -
I would greatly appreciate help with what seems to be an easy question. I'm interested in a formula that will return the column name rather than the number. For example, if I had the data
A, B, C
Apples, Bananas, Carrots

and I wanted to look up the column name for Carrots, what formula would return the value "C"?

Thanks so much!

**Special-K** · 02-29-2012, 03:35 PM

Does this help any?

http://www.mrexcel.com/forum/showthread.php?t=71978

**tom1977** · 02-29-2012, 03:41 PM

hi look at attachment it works good only for columns with 1 letter.

**vidyuthrajesh** · 02-29-2012, 04:32 PM

try this..

=LEFT(ADDRESS(1,MATCH(C5,1:1,0),4,1),FIND("1",ADDRESS(1,MATCH(C5,1:1,0),4,1),1)-1)

**ChemistB** · 02-29-2012, 04:39 PM

If your column names are in row 1 (i.e. A,B,C)and the value you want as a reference is in F12 ("carrots"

INDEX($A$1:$C$1,MATCH(F12,$A$2:$C$2,0))

Is that what you are looking for?