Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |