Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a pivot table of data that I would like to complete a lookup on. The
data is in a pivot table because I need some of the data grouped before I complete the lookup on it. I am trying to complete a lookup that first finds the Center then looks for the Client. Once the correct Center and Client are found, then I want it to look up the Month and return the data point. So if I have it lookup Center2, Client4 for Mar., it would return the value of 48. See example table below: A B C D E 1 Center Client Jan Feb Mar 2 Center1 Client 1 22 3 25 3 Client 2 131 108 107 4 Client 3 4 0 0 5 Client 4 25 24 24 6 Client 5 1 0 7 7 Center1 Total 161 135 138 8 Center2 Client 1 0 0 0 9 Client 2 20 4 4 10 Client 3 0 1 6 11 Client 4 36 32 48 12 Client 5 11 1 2 13 Center2 Total 67 38 60 Any ideas on how to set up the lookup would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula assistance needed | Excel Worksheet Functions | |||
Assistance needed with a formula | Excel Worksheet Functions | |||
CODE Assistance needed PLEASE please please | Excel Discussion (Misc queries) | |||
VBA Assistance Needed | Excel Discussion (Misc queries) | |||
Pivot Table Assistance Needed | Excel Worksheet Functions |