• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Partial matches and near dates matches


are what is problematic here, if any solution can be found to place those !!
Am using office 365,
the file is too large to upload ,
so herewith it is
Last edited:
The file is too big to sort through but from the question itself, the closest lookup values from a list are given by
= LET(
      upper, XLOOKUP(lookupValues, lookupArray, lookupArray, MAX(lookupArray), 1),
      lower, XLOOKUP(lookupValues, lookupArray, lookupArray, MIN(lookupArray),-1),
      IF((upper+lower)/2 < lookupValue, upper, lower)