| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Numeric Values Matching EXACT Date for Criteria
Hi Domenic,
Thank you very much for explanation and corrected Formula. That's Great! Cheers, Sam Domenic wrote: Hi Domenic, [quoted text clipped - 5 lines] What does the +0 actually do? That part of the formula returns the date as a text string. The +0 bit coerces it into a true date value. Cell AB4 contains the two digit number 31 and the month in B22 is June. It returns has #N/A. Should it have returned #VALUE as the 31 June does not exist? =INDEX(OFFSET(Data,0,0,,10),MATCH($AB$4&"/"&TEXT($B22,"mm/yy")+0,Date,0), COLUMN(A:A)) Opening and closing brackets for the lookup value have been omitted. The formula should be as follows... =INDEX(OFFSET(Data,0,0,,10),MATCH(($AB$4&"/"&TEXT($B22,"mm/yy"))+0,Date,0 ),COLUMN(A:A)) Hope this helps! -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
| Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
Threaded Mode
