Auto fill Info into a cell

[esupply]

Hello again everyone,,,,
Happy holidays,

I need a lilttle help if anyone is willing. i need to get some information (price) automatically put into another cell when an item from a drop down list is selected, i have attached a workbook to show what i need to do,,,basically if i choose an item from a list in cell a1,,i want cell b1 to show the price of the item,,,and the item is referenced from sheet 3 as well as the price,,,please see attached,,,thanks in advance,,,and happy holidays

[darkyam]

Try =VLOOKUP(C7,Sheet3!$A$1:$B$1959,2,0)

[esupply]

Sweet,,,,,thanks