Lookup type problem

Hi there

i can't seem to crack this problem...i have a grid with ticks (or "T"'s) on it. its probably easier to see the attached.....but for an input of the first column i want to return the corrosponding letter in the first row based on the tick. i have a one to one relationship inside the grid.

this must be quiet easy? i just can't seem to get a right combination of formulas...i know about the lookups and the match formula?

thanks

pete

Hi,

=INDEX($B$1:$F$1,1,MATCH("t",B2:F2,0))

in G2 and copied down gives you the required

dave

ah brilliant thanks....
i can use this but was wondering whether there was a way to have the input as the number and the return value as the letter? its just that i am using it in a linked spreadsheet where the number orders maybe jumbled....if that makes any sence?

i also used this which gave the same result as the formula you posted:
=LOOKUP("t",B2:F2,$B$1:$F$1)

thanks very much

pete