Lookup between lines and columns
 

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.

Lookup between lines and columns
 

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)


"Byron720" wrote:

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.

Lookup between lines and columns
 

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


On Nov 6, 10:47*pm, Byron720
wrote:
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.

Lookup between lines and columns
 

Terrific ! it works great. Thank you

"Sheeloo" wrote:

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)


"Byron720" wrote:

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.