Hi,
I created a drop down list of products that functions in column A. What I'd like to happen is when I choose a product from the list in column A, the associated cost of that item should automatically be entered in column B.

I have the lists that I use on worksheet 2 and they already function in worksheet 1. I just can't figure out how to have the prices entered automatically. I'm sure it's something obvious, just not to me. Any help will be greatly appreciated.

David