Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for pairing 60 different products into 5 price groups
I'm looking for a formula that will allow me to automatically fill in a price
(from a price group containing 5 different price levels) for a listing of 60 to 80 products. Ex: There are 60 different pens - each named differently - that I would like to choose from a drop-down list. Once selected (and depending upon my selection) the pricing for that specific pen would be filled in automatically, from a price list containing 5 or 6 different price levels. i.e. 60 pens in 5 or 6 different price buckets, with the pricing automatically inserted - depending upon your selection. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
Pairing Question | Excel Discussion (Misc queries) | |||
calculate % change in price for each of 200+ products | Excel Discussion (Misc queries) | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
formula for - price times discount times tax = final price | New Users to Excel |