# Pulling names and figures from ranking tables on multiple sheets into another sheet

#### phillexcel

##### New Member
On sheet RANKING DATA 1ST SEPT cells B2:B26 there are a list of names

in cells D2:D26 there are list of numbers (these are basically the number of points that person has got)

The same info is on the sheet RANKING DATA 8TH SEPT but the names in cells B2:B26 will be in a different order as these are ranking tables

I want to be able to pull the numbers that appear in cells D2:D26 on both sheets (adding them together) and then making them appear against the correct name in another sheet labelled BUSINESS MI in cells B20:B46.

The names that appear in the sheet BUSINESS MI will just be in alphabetical order so no need for ranking.

Can anyone help me?

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Something like this changing the references to suit:

=SUM(VLOOKUP(A1,A1:C1,3,0),VLOOKUP(A1,A1:C1,3,0))

Still need help with this one

Something like this changing the references to suit:

=SUM(VLOOKUP(A1,A1:C1,3,0),VLOOKUP(A1,A1:C1,3,0))

I'm getting an error, using the name Alex Smith and trying to collate data from the two worksheets listed in the formula, I'm inputting the following but getting no joy?

=SUM(VLOOKUP('RANKING DATA 1ST SEPT'"ALEX SMITH"A1,A1:C1,3,0),VLOOKUP('RANKING DATA 8TH SEPT"ALEX SMITH"A1,A1:C1,3,0))

Re: Still need help with this one

You have got mixed up there. The lookup value, Alex Smith, is in the result sheet. Lets say in A1.

Replies
10
Views
289
Replies
1
Views
147
Replies
6
Views
423
Replies
1
Views
275
Replies
5
Views
97

1,203,044
Messages
6,053,185
Members
444,643
Latest member
Shipwreck818

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