Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 21
Default Index Match Multiple Criteria Separate Pivot Tables

I am trying to use the index match function with multiple criteria by pulling records from Pivot table1
into Pivot table2. Pivot table1 are Job Orders that show issued labor hours and Pivot table2 show those labor hours expended per month. The information comes from 2 different databases which I pull into access and create the output files to excel. I am trying to pull the issued hours from Pivot table1 into Pivot table2 that lines up to t the matching record in Pivot table2. Not sure if this can be done. I have pasted an example record from both Pivot tables to at least give a visual. Any help would be appreciated. Thank you. Gene

Pivot Table1
Type Project Finish COST FY Cat2 JO Title CAT Iss Hrs
87345 Test Test FY-11 00D 005 Test2 50330 24
00E2 002 Test3 50330 32
003 Test4 50330 16
420 Test5 50330 208
Pivot Table2
JAN
Type COST FY Cat2 JO CAT Exp Hrs Iss Hrs
87345 FY-11 00D 005 50330 0 ???
00E2 002 50330 0 ???
003 50330 0 ???
420 50330 108 ???

Last edited by Gene Haines : March 14th 19 at 01:06 AM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match / Index multiple criteria return multiple results Marty Excel Worksheet Functions 2 May 22nd 10 01:49 PM
Index lookup with multiple match criteria Vance K[_2_] Excel Worksheet Functions 5 July 18th 09 07:08 AM
MATCH and INDEX combination using multiple criteria? John[_140_] Excel Programming 3 March 30th 09 01:20 PM
Index & Match functions - multiple criteria and multiple results [email protected] Excel Worksheet Functions 4 May 2nd 07 03:13 AM
Index/Match Multiple Criteria EstherJ Excel Discussion (Misc queries) 2 March 31st 06 12:54 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"