Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Criteria
This is on Sheet1 (database of prices):
A B C D E F 5 Type I Type II Type III 6 Plate 1/4" Standard .35 .40 .25 7 Plate 1/4" Cut 1.40 1.40 1.40 8 Flat 1/4" Standard .99 .75 ..39 9 Square 1/4" Standard .55 .50 .45 10 Round 1/4" Standard 1.30 2.00 1.75 On the second page, I have four different drop down boxes in which they need to choose 1) Cell H56: Type (I,II, or III), 2) Cell H57: Structure (plate, flat, square, round), 3) Cell H58: Size (1/4", 1/2", etc.), and 4.) Cell H59: Standard or Cut Based on what they choose for the four above, I want to write a formula to choose the price related to those selections. I have tried multiple formulae; however, I can't seem to get it. Below is the closest: INDEX(Sheet1!A5:R56,((AND(MATCH(H57,Sheet1!A5:A57, 0),MATCH(H58,Sheet1!B5:B57,0)))),(MATCH(H56,Sheet1 !D5:R5,0)+3)) The "3" at the end is to move the column over 3 cells since my data range (i.e. Type I) starts in Column D, not Column A. The result of this formula is "Type I" (i.e. Row 5) not .35 (Row 6) (based on: Type I, Plate, 1/4", Standard selections in the drop down boxes) If I am way off base, I am open to other ideas/functions. Thank you VERY MUCH for any assistance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
return multiple records matching multiple criteria | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |