Lookup Value is Between Range 1 and Range 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
+-------------------------------------------------------------------
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup when value is between 2 columns 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy from sheet to sheet when matches criteria 2
vlookup, indexing, oh my.... 4
Calculate between start and end times 2
returning a value in a table referencing ranges 2
lookup/match mult values 3
Trying to match 1 value to multiple columns 10

Back
Top