Hi folks,
My first post here.
I am looking for a formula in cell M3 that can return the next higher value in column A according to the following two conditions:
1. The conduit type in cell M1 calls from the types in B1:I1.
2. The corresponding value in B3:I18 is larger than the required CSA in cell M2.
I have searched Google to find someone who posted a similar question for 3 hours but in vain. Any help would be much appreciated!
Thank you in advance.
My first post here.
I am looking for a formula in cell M3 that can return the next higher value in column A according to the following two conditions:
1. The conduit type in cell M1 calls from the types in B1:I1.
2. The corresponding value in B3:I18 is larger than the required CSA in cell M2.
A | B | C | D | E | F | G | H | I | K | L | M | |
1 | RMC | FMC | RPVC | EB1/DB2/ES2 PVC | MLTFC | NMLTFC | EMT | ENMT | Conduit type: | EMT | ||
2 | Area, mm2 | Area, mm2 | Area, mm2 | Area, mm2 | Area, mm2 | Area, mm2 | Area, mm2 | Area, mm2 | Required CSA: | 300 | ||
3 | 12 | — | 71 | — | — | 119 | 114 | — | — | Minimum size: | 21 | |
4 | 16 | 202 | 198 | 167 | — | 196 | 188 | 186 | 167 | |||
5 | 21 | 354 | 334 | 307 | — | 341 | 328 | 330 | 304 | |||
6 | 27 | 573 | 507 | 507 | — | 549 | 527 | 539 | 506 | |||
7 | 35 | 985 | 792 | 792 | — | 965 | 937 | 940 | 894 | |||
8 | 41 | 1336 | 1140 | 1140 | — | 1257 | 1257 | 1288 | 1230 | |||
9 | 53 | 2199 | 2027 | 2027 | 2027 | 2068 | 2098 | 2132 | 2057 | |||
10 | 63 | 3139 | 3167 | 2951 | — | 3116 | — | 3783 | — | |||
11 | 78 | 4839 | 4560 | 4560 | 4560 | 4776 | — | 5701 | — | |||
12 | 91 | 6458 | 6207 | 6138 | 6138 | 6207 | — | 7451 | — | |||
13 | 103 | 8311 | 8107 | 7870 | 7870 | 8107 | — | 9503 | — | |||
14 | 129 | 13039 | — | 12439 | 12538 | — | — | 13050 | — | |||
15 | 155 | 18811 | — | 17613 | 17613 | — | — | 18821 | — | |||
16 | 200 | — | — | 31225 | — | — | — | — | — | |||
17 | 275 | — | — | — | — | — | — | — | — | |||
18 | 325 | — | — | — | — | — | — | — | — |
I have searched Google to find someone who posted a similar question for 3 hours but in vain. Any help would be much appreciated!
Thank you in advance.