Return value in row 2 based on last non-zero in row 4

[chunk6649]

I am trying to return the value in row 2 based on the last none zero in row 4. With the formula =INDEX($I$2:BP$2,1,MATCH(1,INDEX(--((1/$I4:BP4)>0),0),0)) it will pull the value in row 2 if the value in the cell is .5 or less. I may have zeros in my row as well, so I would want it to pull the last row.

For example, I might have the following values in row 4. I would want the value to be retuned from the cell that the 300 is in. The current forumla would return the value in row to for the .25.

500	25	.25	0	300

Thank you,

Sean

 

[Domenic]

Try...

chunk.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2		Header1	Header2	Header3	Header4	Header5	Header6	Header7	Header8	Header9	Header10		Result
3
4		500	25	0.25	0	300							Header5
5		500	25	0.25	0	300	75	200	0				Header7
6
Sheet1

Cell Formulas
Range	Formula
T4:T5	T4	=LOOKUP(2,1/(I4:R4<>0),$I$2:$R$2)

Hope this helps!