Hi Rebel,

Welcome to our forum!

There are lots of ways to achieve this, but it's not clear how you want the information presented. You mention looking up the item number (C) and then add up the value in the quantity (E), I'm guessing these are column references, but since you're not showing that information I'm not sure.

The simplest way to look up an item and return a value from a corresponding column is to use a VLOOKUP formula.

If you're still stuck after reading that post, please upload a sample Excel file with your data and desired output and we can help you further.

Mynda

Hi Mynda

Thanks for your reply. I am brand new to this so forgive my ignorance.

I know how to do simple formula's like VLOOKUP's however from what I can gather from other posts, I need to do a VLOOKUP and a SUM.

What I am trying to do is lookup the instances of an item number in column C, add the number is column E and return the result in J, K, L for each item.

I have attached the file this time so hopefully, you'll see what I mean 🙂

Thanks, Rebel

Hi Rebel,

Thanks for providing the example file. It's clear now that you need a SUMIF formula. See file attached.

Mynda

Thanks so much. All working now!