| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup against pivot table with multiple instances
HELP!
I'm putting together a spreadsheet that summarises devices removed. On one tab I have my pivot table which lists all the device types and a count against the reference number they were removed against. On my second tab I have a list of each device type and am trying to look up for type the total number removed. I tried a VLOOKUP but as the same device type occurs for multiple reference numbers it only grabs the first occurrence. Anyone able to offer any help ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Repeats Names in multiple rows | Excel Discussion (Misc queries) | |||
| Pivot Table with multiple worksheets | Excel Discussion (Misc queries) | |||
| Multiple table lookup | Excel Discussion (Misc queries) | |||
| Multiple columns in a pivot table | Excel Discussion (Misc queries) | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
