I've a workbook with 3 sheets.
In sheet 3 I want to use a value as a lookup from the other 2 sheets and return something from either sheet. Ordinarily I would use vlookup.
Is it possible to use vlookup or similar function to lookup if a value is between two dates?
How about
=SUMPRODUCT((A1:C4>D1)*(A1:C4<E1)
where D1 is a start date and E1 an end date with lookup table A1:C4
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks