Excel Drop Down List Automatically Changes Product Name to Code

[bsldesigns]

Trying to use this for a 6 table sheet. How do I code for multiple tables?

I'm making a quote sheet. In the "Quotes" worksheet you have a dropdown with Item names and after you select the Item it puts "ItemPrice" in the cell which is part of a larger formula to calculate total price.

[Sbhabhi]

THANK you very much.Solved a big problem

[weyamyohan]

Thanks u so much

[TheKeefe95]

THANK YOU SO MUCH!

[anandvshah1]

Good use of lists.....