Worksheet #1 - Standing Database of inventory
Column A = Kool, Marlboro, Newport, Snickers, M&M, Miller, Bud, Labatts
(Actual data is product number)
Column B (product catagory = Cigarette, Candy, Beer

WorkSheet #2 - Daily tally of what was actually sold sold but i need to know
the catagory of the product not the actual product placed in column D
Column A = Kool, Kool, Snickers, Bud,Labatts, Newport
Column B = Quantity sold
Column C = Price
Column D = Would like to reference Worksheet #1 and insert the Catagory of
the product name that is listed in Column B of Worksheet #1.

Worksheet #2 is a copy and paste from a Crystal report.
Expected results for above entries on Worksheet #2 in Column D would be
"Cigarette, Cigarette, Candy, Beer, Beer, Cigarette....

You want Vlookup, as in:
=vlookup(a2,sheet1!A:B,2,false)

Regards,
Fred.

"dadtofive" wrote in message
...
Worksheet #1 - Standing Database of inventory
Column A = Kool, Marlboro, Newport, Snickers, M&M, Miller, Bud, Labatts
(Actual data is product number)
Column B (product catagory = Cigarette, Candy, Beer

WorkSheet #2 - Daily tally of what was actually sold sold but i need to
know
the catagory of the product not the actual product placed in column D
Column A = Kool, Kool, Snickers, Bud,Labatts, Newport
Column B = Quantity sold
Column C = Price
Column D = Would like to reference Worksheet #1 and insert the Catagory of
the product name that is listed in Column B of Worksheet #1.

Worksheet #2 is a copy and paste from a Crystal report.
Expected results for above entries on Worksheet #2 in Column D would be
"Cigarette, Cigarette, Candy, Beer, Beer, Cigarette....

Thank You Fred... Works great...

"Fred Smith" wrote:

You want Vlookup, as in:
=vlookup(a2,sheet1!A:B,2,false)

Regards,
Fred.

"dadtofive" wrote in message
...
Worksheet #1 - Standing Database of inventory
Column A = Kool, Marlboro, Newport, Snickers, M&M, Miller, Bud, Labatts
(Actual data is product number)
Column B (product catagory = Cigarette, Candy, Beer

WorkSheet #2 - Daily tally of what was actually sold sold but i need to
know
the catagory of the product not the actual product placed in column D
Column A = Kool, Kool, Snickers, Bud,Labatts, Newport
Column B = Quantity sold
Column C = Price
Column D = Would like to reference Worksheet #1 and insert the Catagory of
the product name that is listed in Column B of Worksheet #1.

Worksheet #2 is a copy and paste from a Crystal report.
Expected results for above entries on Worksheet #2 in Column D would be
"Cigarette, Cigarette, Candy, Beer, Beer, Cigarette....


.