Dear Excel(lent) users,

I have a sheet in which I have the following columns:
A : Date
B: Number range, cummulatif +3 (positive estimation)
C: Number range, cummulatif -2 (negative estimation)

Now I want to know the following:
I want to know the date in A, which is the first date a certain number is
shown in Column B.

For instance:
A B C
---------------------------------------------
23-04-07 10 8
24-04-07 17 9
25-04-07 23 11
26-04-07 28 12
27-04-07 35 15
28-04-07 40 17
etc etc

The first time the number 17 appears in column B is on 24-04-07 so I want
that date as a return, the first time the number 17 appears in column C is on
28-04-07 so I want that date as a return.

Can you please help me ??



--
** Fool on the hill **