I have succesfully created a list using Data, Validation option.

This puts the name of the product in the cell C6, but I am trying to
find a way of automatically bringing the cost price of the product into
D6 and the retail price into E6.

I have tried using a string of if statements but after around 10
multiples, it comes up as an error all the time.

Any ideas please

Thanks


--
Markyboy
------------------------------------------------------------------------
Markyboy's Profile: http://www.excelforum.com/member.php...o&userid=29493
View this thread: http://www.excelforum.com/showthread...hreadid=491929