we_B_jamin
New Member
- Joined
- May 14, 2014
- Messages
- 2
Hello All,
I am new to Mr. Excel, and I have usually been able to solve issues without assistance but alas, my spreadsheets are getting more complex.
To keep it brief:
I need to look up a table of life expediencies, information in the table is organized as follows:
<colgroup><col><col span="4"><col><col><col><col><col></colgroup><tbody>
</tbody>
A, B, C etc.. are the columns (ignore "F" as it will be removed)
Basically I have 3x drop down lists.
1) Table: New vs. Old
2) Status: Non Smoker vs. Smoker
3) Sex: Male vs. Female
The last input is the age, which corresponds to column A (input cell)
I can't figure out how to do a nice, clean, index & match. I though of creating a reference table with a vlookup to select the column.
Any ideas
Thanks for your help.
I am new to Mr. Excel, and I have usually been able to solve issues without assistance but alas, my spreadsheets are getting more complex.
To keep it brief:
I need to look up a table of life expediencies, information in the table is organized as follows:
A | B | C | D | E | F | G | H | I | J |
NEW Life Expectancy Table | OLD Life Expectancy Table | ||||||||
Non Smoker | Smoker | Non Smoker | Smoker | ||||||
Age | Male | Female | Male | Female | Age Nearest | Male Non Smoker | Female Non Smoker | Male Smoker | Female Smoker |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
15 | 59 | 71 | 60 | 67 | 15 | 64 | 68 | 56 | 63 |
16 | 60 | 70 | 59 | 66 | 16 | 63 | 67 | 55 | 62 |
17 | 61 | 69 | 58 | 65 | 17 | 62 | 66 | 54 | 61 |
18 | 62 | 68 | 57 | 64 | 18 | 61 | 65 | 53 | 60 |
19 | 63 | 67 | 56 | 63 | 19 | 60 | 64 | 52 | 59 |
<colgroup><col><col span="4"><col><col><col><col><col></colgroup><tbody>
</tbody>
A, B, C etc.. are the columns (ignore "F" as it will be removed)
Basically I have 3x drop down lists.
1) Table: New vs. Old
2) Status: Non Smoker vs. Smoker
3) Sex: Male vs. Female
The last input is the age, which corresponds to column A (input cell)
I can't figure out how to do a nice, clean, index & match. I though of creating a reference table with a vlookup to select the column.
Any ideas
Thanks for your help.