Hi All

I had 2 worksheets as follow:

Sheet1 contains hundreds of products name, product serial nos, cost, selling
price, date of purchase, etc.

I had name the range of products name as name.

In Sheet2, using data validation dropdown list, , whenever I select one
product, I want certain info to be displayed in the cells I had intended to.

e.g.

A1 when "Rod" was selected from dropdown list,

to display automatically the related info as follow:
C1 to display the date of purchased,
D1 to display serial number,
B4 to display selling price

Thanks