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
And the customer workbooks three different ones would look like this.
I need to reference the master workbook and report the customer price, by looking at OUR ITEM and match CUSTOMER NAME
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 NAME | OUR ITEM | CUSTOMER 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.
I need to reference the master workbook and report the customer price, by looking at OUR ITEM and match CUSTOMER NAME