| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date match problem
On Tuesday, January 29, 2013 10:18:12 AM UTC-5, Claus Busch wrote:
Hi, Am Tue, 29 Jan 2013 07:09:12 -0800 (PST) schrieb Doing MATCH(F3,A2:A16) returns 15. It should return 4. you didn't enter the third term of the formula. Try: =MATCH(F3,A2:A16,0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 That did the trick. Thank you Claus! Amy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Date/Time to Date list | Excel Worksheet Functions | |||
| Date match problem | Excel Discussion (Misc queries) | |||
| Match date problem | Excel Discussion (Misc queries) | |||
| How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
| Problem w/ Match prop vs. Match method | Excel Programming | |||
Threaded Mode
