Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help needed
Hell all i hope someone can help here and i hope i can explain things ok. Righ here goes I have a table GCC Board Sits 23 (2006) 24 (2007) 25 (2008) 26 (2009) Feb-06 Feb-07 Feb-08 Feb-09 Sub Sgt on or before 31/03/2003 31/03/2004 31/03/2005 31/03/2006 And ROD after 31/07/2013 31/07/2014 31/07/2015 31/07/2016 What i am trying to do is enter an ROD date in a cell which will give me the Sub Sgt date this is the ROD date minus 10 years 4 months. Once this has been calculated I wanted the cell next to it to tell me what GCC Board sits i.e. 23 have tried the hlookup but just keep getting the N/A error has anybody any ideas please, and i hope i have explained this correctly. Cheers Andy -- andyd358 ------------------------------------------------------------------------ andyd358's Profile: http://www.excelforum.com/member.php...o&userid=35069 View this thread: http://www.excelforum.com/showthread...hreadid=548108 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
Needed: worksheet export help | Excel Discussion (Misc queries) | |||
"In Today's Dollars" help needed... | Excel Worksheet Functions | |||
VLOOKUP help needed! | Excel Worksheet Functions |