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

Hi,

Take a look at VLOOKUP.

"vcff" wrote: Suppose your product name filter is in A1 and suppose your
table with all the info is in Sheet2!A1:H1000 with the product names in
column A.

=VLOOKUP($A$1,Sheet2!$A$1:$H$1000,2,False)

This would return the item in the 2nd column of the table for which there
was a match of A1 on the range A1:A1000 in the table.

You can copy this formula whereever you need it and just change the 3rd
argument as needed.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

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

Yes, it works.

Thanks

vcff

"Shane Devenshire" wrote:

> Hi,
>
> Take a look at VLOOKUP.
>
> "vcff" wrote: Suppose your product name filter is in A1 and suppose your
> table with all the info is in Sheet2!A1:H1000 with the product names in
> column A.
>
> =VLOOKUP($A$1,Sheet2!$A$1:$H$1000,2,False)
>
> This would return the item in the 2nd column of the table for which there
> was a match of A1 on the range A1:A1000 in the table.
>
> You can copy this formula whereever you need it and just change the 3rd
> argument as needed.
>
> If this helps, please click the Yes button
>
> Cheers,
> Shane Devenshire
>
> > 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
> >
> >