Lookup and populate new worksheet

[WildForest2017]

Hello,


I need some help from an excel whizz if possible??
Can this be achieved in excel? My bookkeeper has informed me that the following task is beyond his scope!!




Objective:
Populate Worksheet 3 with a list of all current active products listing the product name, brand name, quantity of units sold from last financial year and
the current retail price.




Worksheet 1 - Current Active products
A1 - Name
B1 - Brand
C1 - Retail Price Inc GST
D1 - Stock Level
E1 - Date Added


Worksheet 2 - Unit sales for all products (including inactive) for last financial year
A1 - name
B1 - brand
C1 - orders
D1 - gross_revenue
E1 - qty_sold


Worksheet 3 (new master List) - Current Active products - new list with combined fetched data
A1 - Name
B1 - Brand
C1 - qty_sold
D1 - Retail Price Inc GST




Ideas on How:
Lookup W1 for product name A2
Find match in W2 for product name
Populate W3 with W1's respective product name, brand name, retail price & W2's unit sales.

Any help would be greatly appreciated

 

[Special-K99]

Not saying Im going to solve this but it would help to have some data as well as descriptions, maybe you're expected results from that data too.


You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[WildForest2017]

Thanks for the reply

Heres a sample of the excel workbook I'm referring to:
https://u14431298.dl.dropboxusercontent.com/u/14431298/for excel forums.xlsx