R
Rizitsu
I have tried both your solutions, i return a #VALUE! Error when place
in both scenarios.
Here is the method in which i set up the data.
SMS SME Date Result
Mon 29/12/2003 Sun 25/01/2004 01/03/04 =VLOOKUP((G5),2,2,(E5:F16))
Mon 26/01/2004 Sun 29/02/2004
Mon 01/03/2004 Sun 28/03/2004 =TEXT(G5,E5:F16)
Mon 29/03/2004 Sun 25/04/2004
Mon 26/04/2004 Sun 30/05/2004
Mon 31/05/2004 Sun 27/06/2004
Mon 28/06/2004 Sun 25/07/2004
Mon 26/07/2004 Sun 29/08/2004
Mon 30/08/2004 Sun 26/09/2004
Mon 27/09/2004 Sun 31/10/2004
Mon 01/11/2004 Sun 28/11/2004
Mon 29/11/2004 Sun 26/12/2004
As you can see, my cell reference for the above service dates ar
within the range E5:F16. Cell G5 is the Date i want to check agains
the service dates.
If this is plausable, please help.
Thanks.
PSA
+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelforum.com/attachment.php?postid=2788
+-------------------------------------------------------------------
in both scenarios.
Here is the method in which i set up the data.
SMS SME Date Result
Mon 29/12/2003 Sun 25/01/2004 01/03/04 =VLOOKUP((G5),2,2,(E5:F16))
Mon 26/01/2004 Sun 29/02/2004
Mon 01/03/2004 Sun 28/03/2004 =TEXT(G5,E5:F16)
Mon 29/03/2004 Sun 25/04/2004
Mon 26/04/2004 Sun 30/05/2004
Mon 31/05/2004 Sun 27/06/2004
Mon 28/06/2004 Sun 25/07/2004
Mon 26/07/2004 Sun 29/08/2004
Mon 30/08/2004 Sun 26/09/2004
Mon 27/09/2004 Sun 31/10/2004
Mon 01/11/2004 Sun 28/11/2004
Mon 29/11/2004 Sun 26/12/2004
As you can see, my cell reference for the above service dates ar
within the range E5:F16. Cell G5 is the Date i want to check agains
the service dates.
If this is plausable, please help.
Thanks.
PSA
+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelforum.com/attachment.php?postid=2788
+-------------------------------------------------------------------