Colin,
Have a look at this excellent site:

http://www.contextures.com/xlDataVal11.html

"Colin" wrote:

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