| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up a value using a range
Hello all. I hope someone can help me figure this one out. So here we go.... I have a spread sheet that you plug in a date and then enter another date manually. The second date is the on I would like to automate. I need the first date to be complared in a range of dates and then return the effective date. Example: Entered date - 01/08/2006 Range Table: Effective: 01/01/2006 - 01/05/2006 01/05/2006 01/06/2006 - 01/10/2006 01/10/2006 01/11/2006 - 01/15/2006 01/15/2006 I would like it to return the 01/10/2006 effective date for that range. Any help is appreciated. -- Nokose451 ------------------------------------------------------------------------ Nokose451's Profile: http://www.excelforum.com/member.php...o&userid=30528 View this thread: http://www.excelforum.com/showthread...hreadid=501807 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
