| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup(date, range,3)
Hello Group,
I am doing a vlookup on a date, I will take the closest date, so have not used the last parameter. It returns the last date in the list always. Both the date in the Lookup and in the table are type = 1, a number. Am I missing something here or is it not possible to do this? Thanks, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup using match and date range | Excel Discussion (Misc queries) | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| finding a max date in a range in vlookup data | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
