Lookup Value is Between Range 1 and Range 2

C

Corissa

I have the following data:
Col A = Start Date
Col B = End Date
Col C = Week Number

Is there a way to do a lookup function to display the Week Number if a user
enters a date that is between Col A and Col B?
 
C

cscorp

Corissa,

I don't think the vlookup as designed can help you to do that.
designed a small function called "WeekFinder". The spreadshee
attached is an example on how to use it. The code is unprotected an
documented. Please, verify and test it. It is in a zip file becaus
this system do not allow Excel Attachments.

Let me know if that helps.

regards

Juan Carlo

+-------------------------------------------------------------------
|Filename: WeekFinder.zip
|Download: http://www.excelforum.com/attachment.php?postid=3462
+-------------------------------------------------------------------
 
Top