Return data from catagory
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.... |
Return data from catagory
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.... |
Return data from catagory
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.... . |
All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com