K
Kyle Jamison
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
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