Index/Match/Vlookup formula problems

[Glaswegian]

I'm using the matrix below to produce and rate that users should charge their customers. A, B, C and D are 'segments' and 1-16 represents the customer rating. Thus a customer rated as 6 and segment B would be charged 3.00. Users input the segment and rating into 2 separate cells.

credit submission v2.xls
	Z	AA	AB	AC	AD
5		A	B	C	D
6	1	2.00	2.00	2.75	3.00
7	2	2.25	2.25	2.75	3.00
8	3	2.25	2.50	3.00	3.25
9	4	2.25	2.50	3.25	3.50
10	5	2.50	2.75	3.50	3.50
11	6	3.00	3.00	3.50	4.00
12	7	3.00	3.00	3.75	4.00
13	8	3.00	3.00	3.75	4.25
14	9	3.25	3.25	4.00	4.50
15	10	3.25	3.50	4.50	4.75
16	11	3.50	3.75	4.75	5.50
17	12	3.75	4.00	6.00	10.00
18	13	4.00	4.80	7.50	12.75
19	14	4.25	6.25	9.75	16.75
20	15	4.80	7.50	11.75	20.50
21	16	6.00	9.00	13.50	22.50
DFAS

Based on the user input I have tried to come up with a formula to put the correct rate into a cell, but my formula attempts are not working. So far I've tried
=INDEX(AA5:AD21,MATCH(S6,Z6:AD21,0),MATCH(S7,AA5:AD5,0))

and

=VLOOKUP(S6,Z5:AD21,MATCH(S7,AA5:AD5,0),FALSE)

but with no success. Could someone kindly point out what I'm doing wrong?

Regards

 

[fairwinds]

Hi,

you just have the ranges a little bit of.

Use the VLOOKUP and change it to:

=VLOOKUP(S6,Z6:AD21,MATCH(S7,Z5:AD5,0),0)

 

[Glaswegian]

Fairwinds

Thanks!!

Regards