coding for connection between two sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tushar joshi - 24 Mar 2006 10:17 GMT

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.

Reply to this Message

Ardus Petus - 24 Mar 2006 10:33 GMT

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

> i need to devlope a format which contains two excel sheets.
> one sheet having columns named as sr no., products and the details of
[quoted text clipped - 4 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message