Very simple match function help
 

Oh Wise Ones,
I'm kinda embarrassed by this one but I can't get it
to work. If I have =NOW() in I3 and in G9:G20 I have these dates:
2/03/07
3/03/07
4/03/07
5/03/07
.......
1/03/08

Shouldn't (in J3) =MATCH(I3,G9:G20,1) return 4/01/07? It returns 2/02/2008 I
need the get the closest to but more than todays date from that column.
Please help

Thanks,
Mike

Very simple match function help
 

Thanks Mike! That did the trick. I would have thought it would be simpler
than that though.

Mike

"Mike" wrote:

Try this entered asn an array formula (ctrl+shift+enter)

=INDEX(G9:G20,MATCH(MIN(IF(G9:G20-I3=0,
G9:G20,FALSE)),IF(G9:G20-I3=0,G9:G20,FALSE),0))

Will that do?

Mike

"Mike K" wrote:

Oh Wise Ones,
I'm kinda embarrassed by this one but I can't get it
to work. If I have =NOW() in I3 and in G9:G20 I have these dates:
2/03/07
3/03/07
4/03/07
5/03/07
......
1/03/08

Shouldn't (in J3) =MATCH(I3,G9:G20,1) return 4/01/07? It returns 2/02/2008 I
need the get the closest to but more than todays date from that column.
Please help

Thanks,
Mike