Return column name of table based on an entry

[Manosh]

Hi,
I'd like to return the name of the column based on a user providing an entry.
Here is an example:

T1 T2 T3
a d g
b e h
c f i

If the database contains the letter 'e' i should be able to reference T2, i then T3 and so forth.
I tried to use match/ index but i am probably doing this wrong as match doesnt appear to work on more than one column or row.

Many thanks in advance!!!

 

[Khalid NGO]

Hi Manosh,
Can you upload a sample file, it will be easy for experts to know exactly what is your requirement.

BR
Khalid.

 

[Manosh]

Hi Manosh,
Can you upload a sample file, it will be easy for experts to know exactly what is your requirement.

BR
Khalid.

Hey Khalid,
Thanks so much for your quick response. Here is the structure of the file...

 

[Faseeh]

Hi Manosh,

Please try this:

=IFERROR(INDEX($G$2:$I$2,SUMPRODUCT(($G$3:$I$13=B3)*COLUMN($G$2:$I$2))-6),"")

 

[Manosh]

Hi Manosh,

Please try this:

=IFERROR(INDEX($G$2:$I$2,SUMPRODUCT(($G$3:$I$13=B3)*COLUMN($G$2:$I$2))-6),"")

Brilliant! Works

 

[Manosh]

Brilliant! Works

Hi,
Thanks for this.
How do I make this work if i have to take the assumptions sheet to the next page?

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Manosh]

Hi ,

See this file.

Narayan

Gosh! I dont get this but it works!
But is there a way for it to prevent reporting the first column label if it doesn't find the record?

 

[NARAYANK991]

Hi ,

See this file.

Narayan