Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup Value is Between Range 1 and Range 2
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Value is Between Range 1 and Range 2 | Excel Worksheet Functions | |||
Range Lookup | Excel Discussion (Misc queries) | |||
Lookup from a range on separate sheets | Excel Discussion (Misc queries) | |||
Range Lookup? Is there such a thing like this? | Excel Worksheet Functions | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions |