Hey,
I have a bit of a problem, I need a formula to look something up based on two variables.
So the info that will be input is Name, Group and Age, eg.
Name: John
Group: Blue
Age: 40
Member Price:
I need it to draw the member price based on the group and age;
<tbody>
</tbody>
I've organized the table in my spreadsheet so that it only lists the youngest age, and I've tried using INDEX and MATCH with IF, and SUMPRODUCT (which I know won't work unless I list every age from 1-99), and nothing works...I'm really stuck on this, so hopefully someone knows a solution to my problem.
I have a bit of a problem, I need a formula to look something up based on two variables.
So the info that will be input is Name, Group and Age, eg.
Name: John
Group: Blue
Age: 40
Member Price:
I need it to draw the member price based on the group and age;
Group | Age Range | Member $ |
Red | 10-14 | $16,000 |
Red | 15-16 | $17,000 |
Red | 17-18 | $18,000 |
Orange | 19-24 | $20,000 |
Orange | 25-29 | $24,000 |
Blue | 30-32 | $26,000 |
Blue | 33-34 | $32,000 |
Blue | 35+ | $36,000 |
<tbody>
</tbody>
I've organized the table in my spreadsheet so that it only lists the youngest age, and I've tried using INDEX and MATCH with IF, and SUMPRODUCT (which I know won't work unless I list every age from 1-99), and nothing works...I'm really stuck on this, so hopefully someone knows a solution to my problem.