You can use a drop-down list but with a lot of items this may not be a good
idea. Use VLOOKUP to take the selected item number from an input cell or from
the Pick List (I am assuming you are using this Data Validation feature) and
return the unit price, description etc. in your 2nd worksheet. This means
your item list 1st column will have to be sorted in ascending order. Specify
an exact lookup to ensure your user does not input an item not in your list
if you will not be using a pick list. Use IFERROR to trap any unwanted
results to return something like "N/A".
--
Gnothi se auton.


"Funkydan" wrote:

Hi All, I was wondering is some one could help me out on using a
dropdown list.

What im trying to acheieve is that one of the work sheets contain
1000's of Items

Columns

A B
C

Ref Discription Unit Cost


Second Worksheet is going to be used to price items.


and the Sheets would contain following columns

A B
C D E

Ref Qty
Discription Unit Cost Total Cost


Under the Columns C i want a Dropdown list which looks up the Items
from the Worksheet with all items with in.

But what i would also like it to do is carry across the Item which is
selected Unit cost in the the column D Next to it.

How do i do this?

Regards

Dan Cawthorne