Two Different Workbooks Receive Data From Columns If Row A Matches

gjfood

New Member
Joined
Oct 15, 2009
Messages
4
Hopefully I'm explaining this correctly. I have two different workbooks, one of them has the master file with all our customer name, our item and customer price. This workbook is updated monthly with new prices.
The other workbook is customer specific (have multiple workbooks per customer). I need to match our item on this workbook to the other workbook and put new price if the customer name matches.
So master would look like this
CUSTOMER NAMEOUR ITEMCUSTOMER PRICE
CUSTOMER AA
1​
$ 0.25
CUSTOMER AA
2​
$ 0.35
CUSTOMER AA
3​
$ 0.45
CUSTOMER AA
4​
$ 0.55
CUSTOMER AA
5​
$ 0.65
CUSTOMER AA
6​
$ 0.75
CUSTOMER AA
7​
$ 0.85
CUSTOMER AA
8​
$ 0.95
CUSTOMER AA
9​
$ 1.05
CUSTOMER AA
10​
$ 1.15
CUSTOMER BB
1​
$ 0.50
CUSTOMER BB
2​
$ 0.65
CUSTOMER BB
3​
$ 0.80
CUSTOMER BB
4​
$ 0.95
CUSTOMER BB
5​
$ 1.10
CUSTOMER BB
6​
$ 1.25
CUSTOMER BB
7​
$ 1.40
CUSTOMER BB
8​
$ 1.55
CUSTOMER BB
9​
$ 1.70
CUSTOMER BB
10​
$ 1.85
CUSTOMER CC
1​
$ 1.05
CUSTOMER CC
2​
$ 1.15
CUSTOMER CC
3​
$ 1.25
CUSTOMER CC
4​
$ 1.35
CUSTOMER CC
5​
$ 1.45
CUSTOMER CC
6​
$ 1.55
CUSTOMER CC
7​
$ 1.65
CUSTOMER CC
8​
$ 1.75
CUSTOMER CC
9​
$ 1.85
CUSTOMER CC
10​
$ 1.95

And the customer workbooks three different ones would look like this.

1670518776746.png
1670518801206.png
1670518817552.png

I need to reference the master workbook and report the customer price, by looking at OUR ITEM and match CUSTOMER NAME
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

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
Back
Top