Lookup and populate new worksheet

WildForest2017

New Member
Joined
Aug 23, 2017
Messages
2
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 :)
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
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.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,126,944
Messages
5,621,753
Members
415,854
Latest member
Tutu123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top