Posted to microsoft.public.excel.worksheet.functions

Mike K

external usenet poster

Posts: 104

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very simple match function help	Teethless mama	Excel Worksheet Functions	1	March 28th 07 02:05 AM
Very simple match function help	Mike	Excel Worksheet Functions	0	March 28th 07 01:12 AM
Simple (?) Match question	Steve	Excel Worksheet Functions	11	March 12th 07 05:22 PM
index match array function-returning only first match, need last.	Julie Olsen	Excel Worksheet Functions	3	December 29th 06 12:50 AM
Simple match and link	motol	Excel Worksheet Functions	4	July 4th 06 03:06 AM

All times are GMT +1. The time now is 03:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us