If item is selected from drop down list, then populate the dollar amount in another cell

Hello,

I'm new to the forum so bare with me please.

First off, I have used Excel for many years, but I am definitely not an expert. I enjoy having it do what seems to be the impossible. Most times, just a simple Google search will get me where I need to be. Well, I am not getting anywhere today with what I want to do.

My issue is that I am trying to create a running list of Purchase Orders for our records for the year. The spreadsheet that was handed to me has all of the information in it, but when we purchase something new, I am supposed to scroll up and sift through previous orders to look for one that we purchased in the past. Then we just copy and paste the Item description, quantity, price, and total, and then down below it shows the grand total of those purchases for that order. That sucks.

So, what I want to do, is create a drop down list that has all of our items (I was able to create that easily) but then I would like it to automatically populate the Price in the Price column.

I hope that makes sense? So, in other words, I just want to be able to have a pull down of our items, and then have it automatically populate a price from a stored list in the same spreadsheet.

Any help would be greatly appreciated!!!

And go figure, after I search and search and search, and then I create this profile, put up the question, I go back to Google, try a different search and I found it.

Here is the formula I used and it worked like a charm: =VLOOKUP(F83,F46:H80,3,FALSE)

Duh.

Anyways, I look forward to being a part of this group and learning from all of you guru's!!!

Thanks,

Jeff