Search Chart and enter data.. Detailed sample attachment 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!

[Jacc]

This sounds like a basic VLOOKUP to me (assuming the accountno is a unique identifier).
If you have to use both accountno and company than an arrayformula with INDEX MATCH will do the trick.
Is this it or am I missing something?