Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a tricky problem of placing a number within an array...
I have products, DRESS, SHIRT, BLOUSE. Within each product type I have
a selling price structure of OKAY, GOOD, BETTER, BEST. From a list of products I need to take the price of the garment and the type and find the price structure for it. OKAY GOOD BETTER BEST DRESS <19.99 20-29.99 30-48.99 49 SHIRT < 9.99 10-14.99 15-27.99 28 BLOUSE <12.99 13-17.99 18-29.99 30 STRIPE BLUE SHIRT 25 "BETTER" LONG DRESS PURPLE DRESS 60 "BEST" DOT BLOUSE GREEN BLOUSE 15 "GOOD" So the example above reads it's a shirt and takes the price and looks in the other array and says that it falls within the BETTER category. I can't find a function to match within an array and can't think of a way around it. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Problem with array and msgbox | Excel Worksheet Functions | |||
Problem with array and msgbox | Excel Worksheet Functions | |||
Problem with array and msgbox | Excel Worksheet Functions |