Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup formula?
Hey all, I have a list of dates that occur every other saturday for the next
year in excel: 7/26/08 8/9/08 8/23/08 etc... I need to look at a cell that is entered, for example: 8/16, and I need the result in another cell to give me 8/9. So if the date entered (8/16) falls between two dates, the result needs to be the earlier one. Any ideas? I tried if, then statements, but I have 26 dates, so I can nest enough. Any help would be great! Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup formula?
Kelly wrote:
Hey all, I have a list of dates that occur every other saturday for the next year in excel: 7/26/08 8/9/08 8/23/08 etc... I need to look at a cell that is entered, for example: 8/16, and I need the result in another cell to give me 8/9. So if the date entered (8/16) falls between two dates, the result needs to be the earlier one. Any ideas? I tried if, then statements, but I have 26 dates, so I can nest enough. Any help would be great! Thanks! With your dates in A1:A26 and your "date entered" in B1, put the following in C1: =VLOOKUP(B1,A1:A26,1, TRUE) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup formula?
THANK YOU SO MUCH! That is exactly what I needed. You are wonderful!
"Glenn" wrote: Kelly wrote: Hey all, I have a list of dates that occur every other saturday for the next year in excel: 7/26/08 8/9/08 8/23/08 etc... I need to look at a cell that is entered, for example: 8/16, and I need the result in another cell to give me 8/9. So if the date entered (8/16) falls between two dates, the result needs to be the earlier one. Any ideas? I tried if, then statements, but I have 26 dates, so I can nest enough. Any help would be great! Thanks! With your dates in A1:A26 and your "date entered" in B1, put the following in C1: =VLOOKUP(B1,A1:A26,1, TRUE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FORMULA | Excel Discussion (Misc queries) | |||
LOOKUP Formula | Excel Worksheet Functions | |||
Lookup Formula help | Excel Worksheet Functions | |||
Using a Lookup Formula | Excel Discussion (Misc queries) | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |