Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple product selector
Here is my data sheet. B1:G1 is a column selector on anouther worksheet.
Example when I select B1 I want to choose data from this column and return the product or products (A2:A16) that match my selected value. I have been able to make this work backwards if I give the product and column selector I can retrieve the data with an INDEX, MATCH, MATCH. I just can't get it to work the other way. I want to return all products that match. Example: I choose B1 with my selector variable, My data to retrive is 35. Return all products that are = 35. Should be A11 and A16 or MX130(C) and HL250 (C). System Differential Pressure Drop (PSI) A B C D E F G 1 Product 5 10 15 20 25 30 2 AM100(C)-1 7 10 12 14 16 18 3 AM101(C)-1 8 12 15 17 19 21 4 AM102(C)-1 10 14 17 19 21 24 5 AM10x-Ux-1 9 12 15 17 20 21 6 AM10xC1070-Ux-1 4 6 7 8 9 10 7 AMX10x-Ux-1 9 13 15 18 20 22 8 MX127(C) 9 13 15 18 20 22 9 MX128(C) 21 29 36 42 47 51 10 MX129(C) 30 43 52 60 68 74 11 MX130(C) 40 57 70 80 90 99 12 MX131 76 108 132 152 170 186 13 MX132 112 158 194 224 250 274 14 HL150 (C) 18 30 38 44 51 57 15 HL200 (C) 24 40 54 68 77 84 16 HL250 (C) 40 70 96 120 136 150 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summed product of multiple arrays | Excel Worksheet Functions | |||
SUMIF/PRODUCT with multiple Criteria not working | Excel Discussion (Misc queries) | |||
Can I use Sum Product across multiple tabs within a workbook? | Excel Worksheet Functions | |||
selector | Excel Worksheet Functions | |||
selector | Excel Worksheet Functions |