Data inserted in correct locations in chart.. Detailed Sample Included.

[AeroTheManiac]

Attached is a sample of what I need completed.
Monthly, I have to do a chart just like this except slightly more complicated.

In the Sample download, there are three charts, "Sample Chart", "Sample Input", and "Desired Result".
"Sample Chart" has a list of accounts from different companies, The first column being their number, the second being their name, and the third being the money they spent.
The "Money Spent" Column is always blank when I start for ALL companies.

I have another chart, "Sample Input", which contains the prices that I'm supposed to put in "Sample Chart, Money Spent" column.
The thing is, "Sample Input" only has the companies with prices listed.. Not all companies have prices, so this means the "Sample Input" is always a shorter list than "Sample Chart".

What I need help with is the prices from "Sample Input" to be put in the correct position in "Sample Chart". The "Desired Result" chart is what I want it to look like.. exactly like that!

When I do this monthly, I have to scroll through several thousand accounts doing this, and it kills the eyes, hahaha. I have some suggested ideas if interested:

Suggestions:
- Possibly have a macro or formula take the Account # in "Sample Input".. Sample it in "Sample Chart", then copy the price and paste it in the right location.
- Possibly make "Sample Input" have blank rows inserted in the places where it should have the account with no prices.

Thanks a ton for reading this essay of a post!

[AlKey]

Duplicate thread

http://www.excelforum.com/excel-gene...nter-data.html

[Andy Pope]

Give your sample information you have a couple of approaches.

A SUMPRODUCT formula to populate Sample chart

D4: =SUMPRODUCT(($F$4:$F$6=B4)*($G$4:$G$6=C4)*($H$4:$H$6))

Although this may get sluggish if you have thousands of formula.

Alternatively you could use a pivot table. the data set you be made of Sample Input and Sample Chart Data.