# Index and Match Functions

#### csshot2

##### New Member
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!!!

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### Diffy

##### Well-known Member

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

Where are your lists? in Sheet1 and Sheet2?

#### csshot2

##### New Member
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?

Replies
3
Views
468
Replies
3
Views
271
Replies
6
Views
389
Replies
0
Views
977
Replies
9
Views
212

1,191,696
Messages
5,988,149
Members
440,131
Latest member
EricMoz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back