I think I understand what you are shooting for and Xrelanon seems to have
offered the correct solution as far as I can tell.

If you want, send me a sample workbook with the layout as you will be
working with. Does not need to be 1000's of items, a dozen will get the
sheets set up and you can expand it once the concept is developed.

I suspect the lookup formula will look something like this... if you have an
error because the lookup value does not exist in the lookup array you will
return "Booger", otherwise you will return the correct price or whatever.

=IF(ISERROR(VLOOKUP(A1,F1:G3,2,0)),"Booger",(VLOOK UP(A1,F1:G3,2,0)))

HTH
Regards,
Howard

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