statutory redundancy pay

[CrashMatRob]

Hi,
I'm trying to calculate redundancy pay, I have sheet1 with names, age and years service.
another sheet from Gov.uk with a table, with Column A, Age and Row 2 years service.

Is there a way to look at sheet1 age and years service and get the answer from the table(sheet2) looking at Column A and Row 2
i,e sheet1 age 22, years service 3, result should be 1.5

	Length of Service
	1	2	3	4	5
Age	0
17	0	1
18	0	1	1.5
19	0	1	1.5	2
20	0	1	1.5	2	2.5
21	0	1	1.5	2	2.5
22	0	1	1.5	2	2.5
23	0	1.5	2	2.5	3

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

[h=1][/h]

 

[Momentman]

Like this maybe

Excel 2013
	A	B	C	D	E	F	G	H	I
1		Length of Service						Search Age	22
2		1	2	3	4	5		Years of Service	3
3	Age	0						Result0	1.5
4	17	0	1
5	18	0	1	1.5
6	19	0	1	1.5	2
7	20	0	1	1.5	2	2.5
8	21	0	1	1.5	2	2.5
9	22	0	1	1.5	2	2.5
10	23	0	1.5	2	2.5	3
Sheet4

Cell Formulas
Range	Formula
I3	=INDEX($A$2:$F$10,MATCH(I1,$A$2:$A$10,0),MATCH(I2,$A$2:$F$2,0))

 

[CrashMatRob]

Thank you very much Momentman with a little tweaking works great.

Rob