Calculating invoice price from pricing matrix using INDEX/MATCH

Hi guys,

You were all so helpful last time that I would like to trouble you again. I am very new to Index Match and was wondering why this is not working

=INDEX(U:Z,MATCH(E2,U:U,0),MATCH(F2,$V$5:$Z$5))

I know that each return should be;

G2 99.47
G3 32.52
G4 32.52
G5 12.02
G6 12.02
G7 26.47
G8 26.47

But this is what is returning;

E-G is the column and 5 to 11 is the row number

E F G
1 Mobility Mileage INVOICE
2 C1 24.52 £61.72
3 W1 11.24 £24.27
4 W1 10.27 £24.27
5 W1 2.69 W1
6 W1 2.65 W1
7 C1 2.53 C1
8 C1 2.53 C1

U-V is the column and 5 to 11 is the row number

U V W X Y Z
Mob Band 1 Band 2 Band 3 Band 4 Band 5
0 5 10 15 25
5 W1 £12.02 £24.27 £32.52 £55.02 £66.27
6 C1 £26.47 £49.22 £61.72 £74.22 £99.47
7 C2 £40.47 £59.32 £115.47 £136.72 £147.97
8 S1 £94.22 £115.47 £136.72 £157.97 £169.22
9 HD £94.22 £115.47 £136.72 £157.97 £169.22
10 B1 £212.97 £212.97 £247.97 £272.97 £290.47
11 SC £94.22 £115.47 £136.72 £157.97 £169.22

Hopefully the tables stay in the format I tried and you all understand the question and maybe INDEX/MATCH is not the way to go but I am under the impression it would be and I have got it to work before in similar circumstances

Thanks

TJ

Sorry for the delay being pulled every direction today - please find attached the spreadsheet which I was earlier asking about - sorry for the confusion earlier hope this is ok

In G2, try

=INDEX(U$4:Y$10,MATCH(E2,T$4:T$10,0),MATCH(F2,U$3:Y$3,1))

thank you so much

Happy to help. Thanks for the rep!