Pull the row name based on a condition/criteria

[asivaraman]

I am trying to pull the data from the first row (E1, F1, G1 ...) based on a certain condition. If col D - "Penetration limit" is equal or greater than the data between row E to V, i need the row name(E1, F1, G1 ...) to show up under the respective col C.
Example: in Row 4 ---- D4= 40% and N4 =41% (because N4>D4), so i need to pull N1 into C4.

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1				1/1/2015	2/1/2015	3/1/2015	4/1/2015	5/1/2015	6/1/2015	7/1/2015	8/1/2015	9/1/2015	10/1/2015	11/1/2015	12/1/2015	1/1/2016	2/1/2016	3/1/2016	4/1/2016	5/1/2016	6/1/2016
2
3
4		10/1/2015	40%	18%	18%	23%	25%	28%	33%	39%	38%	38%	41%	44%	44%	44%	41%	41%	43%	43%	46%
Sheet1044

Cell Formulas
Range	Formula
C4	C4	=INDEX(E1:V1,MATCH(TRUE,E4:V4>D4,0))
Press CTRL+SHIFT+ENTER to enter array formulas.