Data matching sheets

[Guest]

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.

 

[JW]

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)

 

[Guest]

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