Simple Double index

[Bonkers Bill]

Hello, i should know how to do this by now but i keep getting answers with Vlookup and i need index,
B1-M1 have months of the year, under each month are lists of Takings figures
A2-A30 are suppliers
i need to index(B1:M1, match(AA1 which is the month i want then index(A2:A30,match(Z2 which is the supplier i want to fing the takings figure

i have done these before but i cant for the life of me figure this out, any help apreciated, cheers.

 

[jim may]

Maybe...

=INDEX(B2:M11,MATCH(Z2,A2:A11,0),MATCH(AA1,B1:M1,0))

 

[jim may]

=index(b2:m30,match(z2,a2:a11,0),match(aa1,b1:m1,0))

 

[Bonkers Bill]

Hello Jim, i've entered your last formula which shows that i am getting a match for both matches but every result returns 0.00 when i know they should mostly have results greater than 0.00, any ideas?

 

[Bonkers Bill]

Thanks alot Jim, i had an error in the formula, cheers.