Partial matches and near dates matches

[shili12]

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

examplehelp.xlsx

Shared with Dropbox

www.dropbox.com

 

[Peter Bartholomew]

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)
  )

 

[pecoflyer]

Doesn't look that large.. I don't have access to Dropbox

 

[p45cal]

I have no idea what you want to compare with what to get a partial/nearest match.

 

[shili12]

I have no idea what you want to compare with what to get a partial/nearest match.

after he answered me, unfortunately the file was modified without solution, i also got wrong copy with(out) the LET function

 

[Marc L]

Doesn't look that large.. I don't have access to Dropbox

Smaller file reduced at less than a third :​

 

[shili12]

its only that @Peter Bartholomew did the task but upload the modified file in dropbox, its why everyone is getting the wrong modified one !