V Lookup multiple entires

[Andymc]

Hi all,

I am quite puzzled about an something that isn’t quite working as I'
like it to.

I have the below formula which located a reference then put th
corresponding value into another tab.

Basically, Look for ABC on Sheet 2, locate ABC which has a value of £2
Show ABC's value in Sheet 1 as £2.

The problem: I have multiple duplicate references, so ABC might appear
or 4 times but Sheet 1 doesn’t show the sum of all the ABC references.

I want it to do this: Look for ABC on Sheet 2, locate ABC which has
value of £2, £4, £5. Show ABC's total value in Sheet 1 as £11.

=IF(ISNA(VLOOKUP(D3,Oct13!B$3:E$289,4,FALSE)),0,VLOOKUP(D3,Oct13!B$3:E$289,4,FALSE))

Many thanks for having a look!

And

 

[Claus Busch]

Hi Andy,

Am Thu, 24 Oct 2013 12:57:01 +0100 schrieb Andymc:

=IF(ISNA(VLOOKUP(D3,Oct13!B$3:E$289,4,FALSE)),0,VLOOKUP(D3,Oct13!B$3:E$289,4,FALSE))

VLOOKUP return the first found value
If you a sum try:
=SUMIF(Sheet2!$B$3:$B$289,Sheet1!D3,Sheet2!$E$3:$E$289)


Regards
Claus B.