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!!!
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!!!