ExcelBanter - Very simple match function help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Very simple match function help (https://www.excelbanter.com/excel-worksheet-functions/136453-re-very-simple-match-function-help.html)

Very simple match function help

Sort data in Descending order

=INDEX(G9:G20,MATCH(I3,G9:G20,-1))

"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

Very simple match function help

Teethless,
Your formula returned a #N/A. Not sure why. I used Mike's
solution. Thanks for your help.

Mike

"Teethless mama" wrote:

Sort data in Descending order

=INDEX(G9:G20,MATCH(I3,G9:G20,-1))

"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