Matching Values
Hello,
I have a price list which includes Item #, cost, markup %, and price (approx. 300 products). Now, I want to add approx. 100 more products to the list; and I need to apply a markup % to the new products that will be based on the markup % in the current price list. Is there a way to Match the New product Cost to the closest Existing product Cost and assign it the same markup %? Example: Item # Cost Markup (%) Price Cost (New Product) Markup (%) 4343 2.18 77.98% 3.88 2.10 ? 333 3.25 75.93% 5.72 2.55 ? 334343 4.30 76.31% 7.58 3.50 ? 65656 5.44 70.71% 9.29 6.74 ? 67676 5.99 69.91% 10.18 7.05 ? 787878 6.23 69.69% 10.57 8.88 ? 11212 7.08 69.20% 11.98 9.87 ? 899889 10.09 68.98% 17.05 10.00 ? Thank you in advance. Ed. |
Matching Values
Hello,
I have a price list which includes Item #, cost, markup %, and price (approx. 300 products). Now, I want to add approx. 100 more products to the list; and I need to apply a markup % to the new products that will be based on the markup % in the current price list. Is there a way to Match the New product Cost to the closest Existing product Cost and assign it the same markup %? Example: Item # Cost Markup (%) Price Cost (New Product) Markup (%) 4343 2.18 77.98% 3.88 2.10 ? 333 3.25 75.93% 5.72 2.55 ? 334343 4.30 76.31% 7.58 3.50 ? 65656 5.44 70.71% 9.29 6.74 ? 67676 5.99 69.91% 10.18 7.05 ? 787878 6.23 69.69% 10.57 8.88 ? 11212 7.08 69.20% 11.98 9.87 ? 899889 10.09 68.98% 17.05 10.00 ? Thank you in advance. Ed. |
All times are GMT +1. The time now is 03:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com