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]

 

[Jonmo1]

Are you open to re-arranging that table a little?
Is the first age range 0-11 or 11-21 ?

 

[Jonmo1]

I've assumed it's 11-21, and 0-10 just isn't included.

Delete the to columns, they're not necessary.
So you have columns
A ages
B sad
C happy
D lonely

Try
=LOOKUP(B11,INDEX(B2:D6,MATCH(B10,A2:A6),0),B1:D1)

 

[StephenCrump]

... Also wondering whether the numbers will always be in ascending order L to R?

Perhaps everyone is sad at the start of the month, happy in the middle and lonely at the end?

And why do the oldies get 33 days a month!

 

[Jonmo1]

Perhaps everyone is sad at the start of the month, happy in the middle and lonely at the end?

And why do the oldies get 33 days a month!

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.

 

[jrn1392]

no, the ages are just 11, 22, 33, 44 and 55.
you can rearrange them.

 

[jrn1392]

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

 

[jrn1392]

Are you open to re-arranging that table a little?
Is the first age range 0-11 or 11-21 ?

no, the ages are just 11, 22, 33, 44 and 55.
you can rearrange them.

 

[jrn1392]

I've assumed it's 11-21, and 0-10 just isn't included.

Delete the to columns, they're not necessary.
So you have columns
A ages
B sad
C happy
D lonely

Try
=LOOKUP(B11,INDEX(B2:D6,MATCH(B10,A2:A6),0),B1:D1)

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

 

[jrn1392]

... Also wondering whether the numbers will always be in ascending order L to R?

Perhaps everyone is sad at the start of the month, happy in the middle and lonely at the end?

And why do the oldies get 33 days a month!

Yes, the numbers are in ascending order L to R. It’s just a sample table.