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