Column Letter Lookup

Hi there I am trying to find out what column a cell belongs to and return the letter of that column.

So on sheet 2 it has a list of animals and beside that I want a formula that will match that animal to the animal in the list on sheet 1. So for example the formula next to "Polar Bear" should return the letter "C" as "Polar Bear" is in column C. I have been playing around with this formula and it will work to translate the column number into a column letter. But I don't know how to marry this to a lookup as this formula only takes a specific cell reference.

SUBSTITUTE(ADDRESS(1,COLUMN('Sheet 1'!A1),4),"1","")

Thanks so much for your help in advance!

columnletterlookup.xlsx

Assume you use A3 to enter the animal's name, then you can use this formula if you have less than 27 names on row 1:

=CHAR(64+MATCH(A3,$1:$1,0))

Hope this helps.

Pete

=substitute(address(1,match(a3,1:1,),4),1,)

Thanks everyone so much for your help, this solves it. Tony you are right on the money. I actually needed to use your formula because the example I attached is a simplified version of my document so I do need more than A-Z. I should have specified this initially. But thanks everyone for your responses once again!