Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Very simple match function help
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very simple match function help | Excel Worksheet Functions | |||
Simple (?) Match question | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Simple match and link | Excel Worksheet Functions | |||
Match as well as does not match array function | Excel Discussion (Misc queries) |