Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup discontinued Lines | Excel Worksheet Functions | |||
Lookup function - Wrong info when I add lines to reference spreads | Excel Discussion (Misc queries) | |||
Lookup multiple lines | Excel Worksheet Functions | |||
Format new Lines into Columns | Excel Worksheet Functions | |||
How do I add lines to my rows and columns? | Setting up and Configuration of Excel |