Example tables

In the above example, how would I get the “period” (column C of the Example table) of a certain date (column B of the Example 2 table) using the start and end dates (columns A and B of the Example table)? Basically I want to detect if a date is in between certain dates and return a value to the right of it (kind of like VLOOKUP).

  • did you try something like this example =LOOKUP(2,1/((B5>=mins)*(B5<=maxs)),results) – Ruskes Dec 12 '18 at 6:58

You must log in to answer this question.

Browse other questions tagged .