Thanks for the reply but how do I implement this method exactly?
To get the Prim data (Col A product) to match the Prim/Sec data (col A
product, col B $value, col C P/S), then after the user enters either Prim or
Secondary data in their worksheet using the combo boxes, the data will show
it is P or S on their worksheet after the $value as layed out in Prim/Sec
data.
Where do i do all this?
ta
"JW" wrote:
> Unless I am misunderstanding, I don't see why a second VLookup formula
> wouldn't work. Something like:
> =VLOOKUP(Product, ListSheet!A:C,3,false)
>
> sean wrote:
> > How do you match data from two sheets? Hard to explain but will try.
> >
> > I got a small list of products that are Primary products with no $value and
> > a long list of both Primary and Secondary products with their $value. Using
> > the Prim list, how can i use a formula to match the exact same product in the
> > Prim/Secondary list and show a P or S? The Prim/Sec list contains the
> > Product, $value, P/S. Both lists are in different worksheets as they can be
> > updated.
> >
> > So what i am trying to accomplish is, the Prim/Sec list is used as the
> > vlookup table source in the data entry worksheet. Here the worksheet Product
> > is selected with combo boxes showing the Product, the $value, and I hope the
> > Primary or Secondary catagory.
> >
> > Prim list:
> > Coca Cola
> > Diet Coca Cola
> >
> > Prim/Sec list:
> > Product | $Value | P/S?
> > Coca Cola $2 P
> > Diet Coca Cola $2 P
> > Pepsi $1.90 S
> > Dr.Pepper $1.90 S
> >
> > How do you match the Coca Cola Prim to the Coca Cola $2 list and display a P
> > (both Products match = P)? Pepsi = S because Pepsi is not a Primary product.
> >
> > This will be very helpful to link these sheets up. I can alter the vlookup.
> > thank you.
>
>
|
Similar Threads
