coding for connection between two sheets

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 ***

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" <[email protected]> a écrit dans le message de
news:O9nV%[email protected]...
>
> 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 ***