jrn1392
New Member
- Joined
- Feb 20, 2018
- Messages
- 8
[FONT="]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]
<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>[FONT="]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="]Can anyone help me get the result using INDEX AND MATCH.[/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="]Can anyone help me get the result using INDEX AND MATCH.[/FONT]