Forum Discussion

spinaz007's avatar
spinaz007
Copper Contributor
Dec 28, 2023

How to check which date range an entered date falls between

Hi,  I have the following table below.  As shown below, I would like to user to enter the Part Number "P/N" (in B2) and Date Built (in B3) on Sheet 1.  Based on this data, I want it to look up and ...
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Dec 28, 2023

spinaz007 

As suggested by OliverScheurich but written in a way that merges with my general spreadsheet presentation style

= LET(
    inDate?,     BYROW(dateRange<built, XORλ),
    filled,      SCAN("", partNo, FILLDOWNλ),
    validParts,  IF(inDate?, filled),
    XLOOKUP(part, validParts, revision, "Not available")
  )

where

FILLDOWNλ(p, q)
= IF(q <> "", q, p)

XORλ(v)
= XOR(v)

Resources