vendredi 1 mai 2015

Finding closet value if date is equal to a certain date

I really hope you guys can help me with this. I've been trying all day!

I want a formula that finds the moneyness closest to 100 for a certain date. I made this formula:

=(IF("02-01-2009"=C2:C131104;INDEX($K$2:$K$131104;MATCH(MIN(ABS(K2:K131104-100));ABS(K2:K131104-100);0));""))

But it searches the entire sheet instead of only the rows where the date is 02-01-2009.

The data

Aucun commentaire:

Enregistrer un commentaire