Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Comparison with VLookup
Hi All, I have a vlookup which is looking up sorted dates. Before, or once, it brings the date over, I need to determine if it is <5 days from today. If the date is < 5 days from today's date, it needs to bring the date over, if it is than 5 days from today's date, need to say Current in the date field. My vlookup is below, but now I'm not sure how/where or if I can add the date comparison to this string in some format. =IF(ISNA(VLOOKUP($A$3:$A$126,Cons!$C$3:$F$8770,4,F ALSE)),"",(VLOOKUP($A$3:$A$126,Cons!$C$3:$F$8770,4 ,FALSE))) Worksheet where date is being returned to looks like: Col A Col B Col C Queue # of Accts Oldest Date 5 5 11/29/2005 16 3141 2/22/2006 17 618 2/22/2006 Thanks in advance for any assistance. -- techiemom60 ------------------------------------------------------------------------ techiemom60's Profile: http://www.excelforum.com/member.php...o&userid=20124 View this thread: http://www.excelforum.com/showthread...hreadid=525879 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Comparison with VLookup
Hi All, My husband and I were able to figure this out. Thanks for reviewing. -- techiemom60 ------------------------------------------------------------------------ techiemom60's Profile: http://www.excelforum.com/member.php...o&userid=20124 View this thread: http://www.excelforum.com/showthread...hreadid=525879 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem with Date Time | Excel Worksheet Functions | |||
Confusing VLOOKUP with Indirect reference | Excel Worksheet Functions | |||
vlookup on date to text | Excel Discussion (Misc queries) | |||
Date comparison | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) |