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]

	sad	happy	lonely
ages	from	to	from	to	from	to
11	1	10	11	20	21	30
22	1	11	12	21	22	31
33	1	9	10	19	20	29
44	1	8	9	18	19	28
55	1	12	13	23	24	33
age	22
day	15
result	happy

<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>

[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