Lookup between lines and columns

[Byron720]

Please help me on this. I have this data:

Month1 Month2 Month3 Month4 Month5 Month6
Client 1 1.00 0.50 0.25 0.03 64.00 0.06
Client 2 2.00 1.00 0.50 0.06 32.00 0.13
Client 3 4.00 2.00 1.00 0.13 16.00 0.25
Client 4 32.00 16.00 8.00 1.00 2.00 2.00
Client 5 0.02 0.03 0.06 0.50 1.00 4.00
Client 5 16.00 8.00 4.00 0.50 0.25 1.00

in a different sheet I have cell A2 where I type the client and B2 where I
type the month. I need a formula in cell C2 that automatically gives me the
data based on the table above.

 

[Sheeloo]

Assuming your data is on Sheet2 in A1:G7

Enter this in C2 of your desired sheet
=VLOOKUP(A2,Sheet2!$A$1:$G$7,MATCH(B2,Sheet2!$B$1:$G$1,0)+1,FALSE)

 

[muddan madhu]

in c2 put this formula =INDEX(sheet1!B2:G7,MATCH(A2,sheet1!
A2:A7,0),MATCH(B2,sheet1!B1:G1,0))

 

[Byron720]

Terrific ! it works great. Thank you

Assuming your data is on Sheet2 in A1:G7

Enter this in C2 of your desired sheet
=VLOOKUP(A2,Sheet2!$A$1:$G$7,MATCH(B2,Sheet2!$B$1:$G$1,0)+1,FALSE)