Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Should be easy, but...
OK.
I've got a list of dates expressed as text: January 2006 February 2006 .... .... .... December 2007 I've then got a cell containing the curret reporting period, expressed as text, February 2007 I'm looking for a formula which will look up the current reporting period within my list of dates and return the text date above it. Ultimately, I'll then use a VLookup to return the adjacent data, but I can manage that without too much help. I know this should be easy, but I've been messing about with this for an hour or so now, so... Any help appreciated. Tom. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should be easy but....... | Excel Discussion (Misc queries) | |||
Probably and Easy one | Excel Discussion (Misc queries) | |||
Easy one... but not for me :S | Excel Worksheet Functions | |||
Is there an easy way to... | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel |