Help!!!



I've tried everything but can't get the formula I need to do the following:

I have a table as follows

40 43 45 49
Group 1 10 20 30 40
Group 2 12 22 32 42
Group 3 14 24 34 44

On my spreadsheet I will manually input a Group number and also the value 40 (or 43,45,49). Now in another cell, B1 I want to create a formula that looks up which group I have typed in cell A1 e.g Group 2 and looks up which numeric value if I typed in cell A2 e.g. 43. I want the formula to return the answer 22 in cell B1.

Please please can anyone help. I have tried Index's, Match's, Arrays. I am 80% there but can't finish!!!!

40 43 45 49
Group 1 10 20 30 40
Group 2 12 22 32 42
Group 3 14 24 34 44

Group 1 =MATCH(A6,A1:A4) 45 =HLOOKUP(C6,B1:E4,B6)

A6 has the dropdown menu
B6 has the Match formula
C6 has the drop down menu for the top row
D6 has the final result, the Hlookup formula


40 43 45 49
Group 1 10 20 30 40
Group 2 12 22 32 42
Group 3 14 24 34 44

Group 1 2 45 30 :P

Thanks for your help, I don't think my explanation was clear enough.

However I found the answer from another post:

=Index(the table of values,match(group input,Group 1-3 column,0),match(numeric input,numeric row,0))