Selecting the first time a number appears (part 2)

[Jaydubs]

Hello thanx for your previous reply, I figured it out, but what happens if
the number does not appear in either Column B or C.....?

No I would appreciate a similar formula, which looks for the nearest number
compared to the 17 (for instance 18 in the example below). In this example
the first time 17 or higher is hit is 25-07-07 in Column B and 28-04-07 in
Column C.

A B C
---------------------------------------------
23-04-07 10 8
24-04-07 16 9
25-04-07 23 11
26-04-07 28 12
27-04-07 35 15
28-04-07 40 19

Can you please help again?

 

[Toppers]

See my reply to your earlier posting ... and please avoid duplicate postings.

 

[Jaydubs]

Yes, you are quite right, sorry !
--
** Fool on the hill **

See my reply to your earlier posting ... and please avoid duplicate postings.