Need to return column heading of value in a row

[jrn1392]

[FONT=&quot]I have a table of days for various feelings. Ages are going down column A. In row 1, columns B through G are the feelings. For example:[/FONT]
[TABLE="width: 706"]
<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">[TR]
[TD] [/TD]
[TD="colspan: 2, align: center"]sad[/TD]
[TD="colspan: 2, align: center"]happy[/TD]
[TD="colspan: 2, align: center"]lonely[/TD]
[/TR]
[TR]
[TD="align: center"]ages[/TD]
[TD="align: center"]from[/TD]
[TD="align: center"]to[/TD]
[TD="align: center"]from[/TD]
[TD="align: center"]to[/TD]
[TD="align: center"]from[/TD]
[TD="align: center"]to[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]30[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]31[/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]29[/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]18[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]28[/TD]
[/TR]
[TR]
[TD="align: center"]55[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]33[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]age[/TD]
[TD]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]day[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]result[/TD]
[TD]happy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[FONT=&quot]The user will be asked for the age and the day (A10 & A 11). I need to get the column name where the number is found. The day given could be in between ranges.[/FONT]
[FONT=&quot]Can anyone help me get the result using INDEX AND MATCH.[/FONT]

 

[jrn1392]

I'm gonna go out on a limb and guess that this isn't the real verbiage of the table. Not really about moods and ages.

Yes it’s just a sample table.

 

[Jonmo1]

thanks. but can you also do it using INDEX and MATCH?

I Did use Index and Match.

 

[jrn1392]

I Did use Index and Match.

yes, thank you very much

 

[Jonmo1]

You’re welcome