Return the next higher value in a column with multiple conditions

[PatrickL]

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.

	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.

 

[Cubist]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
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	—	—	—	—	—
Sheet9

Cell Formulas
Range	Formula
L3	L3	=XLOOKUP(L2,FILTER($B$3:$I$16,$B$1:$I$1=L1),$A$3:$A$16,,1)

 

[PatrickL]

It works!

Thank you Cubist!!

 

[Cubist]

You're welcome.