V Lookup multiple entires
 

Hi all,

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

I have the below formula which located a reference then put the 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 3 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 a 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,VL OOKUP(D3,Oct13!B$3:E$289,4,FALSE))

Many thanks for having a look!

Andy

V Lookup multiple entires
 

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,VL OOKUP(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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2