Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching 2nd & 3rd values | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
matching two values | Excel Discussion (Misc queries) | |||
Matching Values | Excel Discussion (Misc queries) | |||
matching values | Excel Worksheet Functions |