Excel Formula to Find Date in Multiple Date Ranges
You can use an Excel formula to check where multiple dates listed in one column, are found between a beginning and ending date range in a separate table, and pull the associated value from a third column that lines up with the date range. See this example:
=LOOKUP(2,1/(G:G<=A2)/(H:H>=A2),F:F)
![](https://static.wixstatic.com/media/af7fa4_f787e1aeb1464e03aa0f315c9d07ee29~mv2.png/v1/fill/w_980,h_382,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/af7fa4_f787e1aeb1464e03aa0f315c9d07ee29~mv2.png)
In the formula, the date you want to search for is in A2. This date must fall between the date range which begins in column G and ends in column H. The value to be associated with the date range is given in column F. So when we search for 7/1/2020, we find that it falls between 4/5/2020 and 9/22/2020, which is the date range during which Model D was manufactured.
Kommentarer