Hi Colin,

Vlookup would seem to do what you want.

=VLOOKUP(F1,$J$1:$K$5,2,0)

Where F1 is the dropdown with the item, J1:J5 is a list of the items in the
dropdown and K1:K5 are the associated product codes for the items.

HTH
Regards,
Howard

"Colin" wrote in message
...
Hi can anyone help please.
I am building an order form
I have put Validation lists in a number of columns, and I want to
atomaticly
ad in a product code from another list, given the data selected in the
other
columns, can this be done?
Thanks in advance.
Colin