View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AW
 
Posts: n/a
Default 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 ?