I have a list of parts and a list of customers. Parts have standard pricing and customers get contract pricing.
My data looks something like this:
Table: standard pricing
PartPriceA$5B$10
Table: Customer pricing
CustomerPrice APrice BX$4-Y$6$9Z-$11...