Formula to compare, add and output to new worksheet

[Morbetta]

I am hoping you can help me. I am trying to do something that I don't believe is too difficult, but really have no idea how to write the formula. Can you offer me some guidance?

What I need to do is compare sales of items from 2 different sources of data (worksheets). There are a total of 2 columns of data on each worksheet. Column A contains the name of an item like "red shirt". Column B contains a number that relates to the number of red shirts that got sold, lets say 10. Now carry this on for 10000+ items with the corresponding number of units sold next to each item. Worksheet 2 has many of the same items as the first sheet, but in a different order.

What I need to do is create a formula that will compare the text values of each cell in Column A on worksheet 1, to column A on worksheet 2, if a match is found, then the number of units sold for each item need to be added together and I want the information output to a third worksheet.

For example.
On worksheet 1, there is an item called "Yellow Shirt" in cell A1, and there is a number in A2 that says "10"
On worksheet 2, there is an item called "Yellow Shirt" in cell A44, and there is a number in B44 that says "6"
I want Excel to find these items, add the values together and output the combined values on worksheet 3 so it shows item "yellow shirt" with a number next to it that says "16"

Where do I begin to solve this problem? Who's smarter than me?

[rcm]

send a sample (non sensitive) excel with the exact structure. It can be done ....

[HaHoBe]

Hiu, Morletta,

yo should have another look at the Forum Rules and change your thread title to a more searchfriendly one than the one you used (Forum Rule #1).

Ciao,
Holger

[Morbetta]

Hi RCM,

See attached excel spreadsheet to get an idea of what I am trying to do. I have manually added the numbers and entered the info on worksheet 3 so you can see what I need the output to look like.

I appreciate any assistance you can provide me.

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Morbetta]

I believe I have an appropriate thread title.

[rcm]

this formula goes in b2 an so on

Please Login or Register  to view this content.