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