Show value that corresponds to other value satisfying conditions

**Alexander_Golinsky** · 05-09-2012, 06:27 AM

Hi all! I need 1 formula, that will do:

1. Find the earliest date from column A which will be greater than the date in D3

3. Display the corresponding to this found date value from column c. That's all.

The result in the follow example would be 0.98717401.

----A-------------B---------------C----------D------
---John---------value------------sum----------------
1/1/2012----0.701536434-----1.688710444---2/14/12-
2/15/2012---0.907412947-----0.98717401------------
3/25/2012---0.079761063-----0.079761063-----------

I thought of array formula but i cannot figure out how it should look. Thanks in advance.

**JBeaucaire** · 05-09-2012, 06:39 AM

Try this array formula:

=INDEX($C$3:$C$5, MATCH(SMALL(IF($A$3:$A$5>D3, $A$3:$A$5), 1), $A$3:$A$5, 0))

...confirmed with CTRL-SHIFT-ENTER to activate the array in the middle.