Formula for pulling value off multiple duplicate PLU

[messicajaree]

Hi there.
I've searched and am assuming that I've misunderstood the reference code for what I'm looking for.
I am doing a very simple cash book setup on Excel, but am trying to simplify it.
Ultimately what I'm trying to do is as per example
I've set up codes, eg 101 is 'a', 102 is 'b' etc etc. On another sheet I need the description pulled through when the code is typed in. On the next sheet, which is actually my main query, I want to add the values of the codes together. So if code 101 had 50 inputs, in various columns, at the same, or varied values, for these to be added up and the total value popped onto a cell. And the same for all the other codes. I'm trying to eliminate a gazillion columns which is messy.
Not sure if this makes sense. Would appreciate help for this. Many thanks. Jess

[popipipo]

Please Login or Register  to view this content.

Try this formula