Index and Match Functions

[csshot2]

Not sure if the subject is on the right track or not....

I need to compare two lists in order to be sure the % in list #1 is equal to the Distribution % in list #2. I assume that index/match/lookup or some variation thereof is what I need to use to do this.

List #1
PersonID Position Last CC WBS %
00000014 50117542 Downie 1012003620 (Null) 7.00
00000014 50117542 Downie 1012555060 (Null) 93.00
00004370 50102228 Buxton 1012003620 (Null) 24.00
00004370 50102228 Buxton 1012555060 (Null) 76.00

List #2
Position Funds Center Grant Distribution %
50117542 1012003620 GMNR 7.00
50117542 1012555060 GMNR 93.00
50102228 1012003620 GMNR 24.00
50102228 1012555060 GMNR 76.00

I am not even sure where to start for this type of formula. I know I would have to find the position in list#1 and then lookup the corresponding position in list#2 but I am not sure how to find the right row to make sure the percentages are equal. Each position may have multiple lines that should total to 100% (see Downie with 2 CC that total 100%). Notice that CC (list#1) = Funds Center (list#2).


Any help would be greatly appreciated!!!

 

[Diffy]

I can help you but I need to know

HOw many rows of data are in each of your lists?

Where are your lists? in Sheet1 and Sheet2?

 

[csshot2]

Thanks for the help!!!!

There are numerous rows in each list (approx 10,000 in list#1 and approx 3,000 in list#2).

Each list is in a separate sheet.

Does this give you what you need?