4 criteria Index Match Lookup table

[we_B_jamin]

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:

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.

 

[PaddyD]

Any reason you can't reorganise your data into a single table:

OldvNew| Gender | Smoker | Age | Expectancy

??

 

[we_B_jamin]

It is in one large table.. I am not sure how this helps. Could you please elaborate?

 

[robin33]

Can anybody help me to find a specific sequence of numbers in given data?

eg: in a data (in column) i want to find and highlight cells (in column) containing sequence 2001 which is repeated throughout the column at irregular intervals. Thanks!
1
1
1
2
2
1
2
5
3
3
3
2
5
6
7
8
6
2
0
0
1
2
1
0
0
2
0
0
1
2
1
0
0