P
phjohnso
I have a workbook with two worksheets in it
worksheet A contains (starting in row 2)
A - Product ID
B - Part Number
C - List Price
D - Customer Price
worksheet B contains (starting in row 2)
A - Part Number
B - Price
I need to put a formula in the customer Price cell of worksheet A that
will lookup the matching part number in worksheet B and use the price
in cell b of worksheet B to populate cell d of worksheet A.
I get daily price updates from a vendor daily and need a way to update
prices on over 4,000 products with the updates they send me.
Thanks in advance,
Sincerely
pj
worksheet A contains (starting in row 2)
A - Product ID
B - Part Number
C - List Price
D - Customer Price
worksheet B contains (starting in row 2)
A - Part Number
B - Price
I need to put a formula in the customer Price cell of worksheet A that
will lookup the matching part number in worksheet B and use the price
in cell b of worksheet B to populate cell d of worksheet A.
I get daily price updates from a vendor daily and need a way to update
prices on over 4,000 products with the updates they send me.
Thanks in advance,
Sincerely
pj