Trying to find a way to post a formula's result in two cells, not just the formula cell.

[James_Mingo]

10/23/2019	108.38	0.19	110.29
10/24/2019	113.35	4.97	110.61
10/25/2019	113.71	0.36	110.94	111.69
10/28/2019	117.08	3.37	111.59	111.90
10/29/2019	117.76	0.68	112.24	112.13	0.10	1	117.76
10/30/2019	117.57	-0.19	112.80	112.34	0.45	1
10/31/2019	115.8	-1.77	113.11	112.48	0.63	1

The value 117.76 is the result of the condition change from 0 to 1 in the preceding cell. I want to

also post that result in another fixed cell, e.g.  $k$2.

[#2 · Accepted solution]

@James_Mingo 

=INDEX(H1:H7,MATCH(TRUE,NOT(ISBLANK(H1:H7)),0))

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

[#3]

That worked, thanks.