I wonder what is the best formula in Numbers to Lookup Values (column C) if one date falls between two dates (columns A y B).
I haver checked all the numbers videos here. “Using Numbers Lookup With Date Ranges” (#1346) is something similar but it has only one column of sequenced dates.
It would be, maybe, interesting to have a video tutorial about this.
START END TYPE
01/01/1900 09/05/1985 A
10/05/1989 31/12/1994 B
01/01/1997 05/06/2013 C
06/06/2016 05/03/2019 D
06/03/2019 14/04/2023 E
Which type -if one- is 01/09/2016?
I think is a useful formula for many businesses to find a value corresponding a specific date.
I guess is not a simple lookup formula. Maybe a combination of INDEX-MATCH and others