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? |
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 |