Drop Down Lists: change neighboring cell

Im trying to implement a drop down list where the list contains a bunch of different products. each product has a different price.

when i select product A the price is $1, product B is $2, product C is $3 etc.

the list contains
A
B
C

i want the cell imediately to the right of the drop down list to change to the correct price when i make my selection in the drop down list. any idea how i would implement this.

Hello MetalDwarf,

Where is the price list saved?

Sincerely,
Leith Ross

not saved anywhere right now. its a new project.
im totally flexible on how to set it up. Suggestions?


i was hoping it would be something as simple as column A is product description column B is price.

when i choose row N in column A the neighboring cell displays the value in column B row N

Hello MetalDwarf,

If you don't want the user to see or change the pricing, I would place the prices on a separate worksheet, protect it, and hide it. You will be able to access it from code, but the user won't be able to change it easily (Excel passwords can be defeated). I have attached a workbook as an example.

Sincerely,
Leith Ross

While Leith Ross provided a great example of one way to do it, it can also be done without using a Macro. Similarly, I'd set up a separate page with "Inventory" (products and prices). Then on the main entry sheet, I'd use a validation to select products, and a vlookup to lookup the prices.

I think both methods would do what you want; in the end, it's a matter of preference.

BigBas

that was EXACTLY what i was looking for
Thanks a million

No problem. I'm glad it worked.

If you need help expanding it, just let me know.