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

[phillexcel]

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?

 

[steve the fish]

Something like this changing the references to suit:

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

 

[phillexcel]

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

 

[steve the fish]

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.

=SUM(VLOOKUP('BUSINESS MI'!A1,'RANKING DATA 1ST SEPT'!$B$2:$D$26,3,0),VLOOKUP('BUSINESS MI'!A1,'RANKING DATA 8TH SEPT'!$B$2:$D$26,3,0))