In Sheet1, assuming serial no is in column A and prod. name in column B;
In Sheet2, assuming your serial no is in A1, enter in B1:
=VLOOKUP(A1,Sheet1!A1:B999,2,TRUE)

HTH
--
AP

"tushar joshi" a écrit dans le message de
...

i need to devlope a format which contains two excel sheets.
one sheet having columns named as sr no., products and the details of
their distributions and reciepts.
second sheet contains the sr no. & products.
i want the the product name (unique) to be displayed in the column as i
enter the sr no in Sheet 1.

*** Sent via Developersdex http://www.developersdex.com ***