I have been able to create a drop down list, but cant work out how to create
a vlookup to auto fill in the price associated with an item.

CELL A1 - DROP DOWN LIST ITEM

CELL A4 - AUTO FILL PRICE FOR THIS ITEM

I would keep the lists for both items and prices in a seperate sheet, but
not sure if they must be next to each other, A1 & A2 for example.

Any help would be good

Thanks