• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

lookup and match formula help please :)

Hi I need some help in filling this spreadsheet in without doing it manually. All the info is coming from the Raw Data tab.
Taking the first section in the data tab (levant classic) I am wanting a formula for the sun of quantity (column F) and the sum of value column G).
So the formula would need to look at the column D for the customer number, look at the product number (for Levant classic it is “1100”) and then populate the total quantity and sales coming from the raw data tab.
Any help would be great thank you.



Well-Known Member
I can't link your columns either with your narrative nor with the headings on the Data sheet, so I've added a pivot table (less than 3 minutes to set up) to give you an idea of how to get the summary data you want. See attached.