Corissa,
I don't think the vlookup as designed can help you to do that. I
designed a small function called "WeekFinder". The spreadsheet
attached is an example on how to use it. The code is unprotected and
documented. Please, verify and test it. It is in a zip file because
this system do not allow Excel Attachments.
Let me know if that helps.
regards
Juan Carlos
+-------------------------------------------------------------------+
|Filename: WeekFinder.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3462 |
+-------------------------------------------------------------------+
--
cscorp
------------------------------------------------------------------------
cscorp's Profile:
http://www.excelforum.com/member.php...o&userid=24015
View this thread:
http://www.excelforum.com/showthread...hreadid=375478