Excel function to get the value of another cell

Question

Image describing the problem http://img215.imageshack.us/img215/3725/20100314235127schedule2.jpg

I hope the image above can explain what I need. :)

Task 1: Get the date when this is the first value in a row

Task 2: get the date when the value is 100

I would also add the actual excel file, but I limited myself to posting only 1 link.

Answer 1

Function for left blue cell:

= IF (COUNTIF (L11: BJ11, "> 0"), index ($ L $ 2: $ BJ $ 2, MATCH (TRUE, INDEX (L11: BJ11> 0,0), 0)), "")

Function for the right blue cell:

= ( (L11: BJ11,100), ($ L $2: $BJ $2, MATCH (100, L11: BJ11,0)), "")