They don't have to be next to each other, certainly not row wise, but they
might just as well be so. The important thing for VLOOKUP is to put the
lookup value, item in your example, in the first column.

As an example, sheet2
A B
1 Item1 26.00
2 Item2 37.34
3 Item3 22.44
etc.

Then on the sheet1, assuming the dropdown is in A1, in say A2, add

=VLOOKUP(A1,Sheet2!A1:B100,2,False)

--
HTH

Bob Phillips

"Julian Campbell" wrote in message
...
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