| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup Value is Between Range 1 and Range 2
One way to do it would be to use sumproduct
=sumproduct(--(A1:A100<=datevalue(D1)),--(B1:B100=Datevalue(D1)),C1:C100) "Corissa" wrote: 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
|
|||
|
|||
|
I'm looking for a "lookup" function that will display the contents of col C
if the date entered is between the start date and the end date. I'm not following how the sumproduct will get me to the correct results. Thanks for your help! "bj" wrote: One way to do it would be to use sumproduct =sumproduct(--(A1:A100<=datevalue(D1)),--(B1:B100=Datevalue(D1)),C1:C100) "Corissa" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 the latest date in a range so it appears as my result | Excel Discussion (Misc queries) | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
Linear Mode
