Hi,

I am currently in the process of trying to return a value based on a
data element being found with a specified date range.

One element is the look up field and then the next two elements are
the From and To dates and the result, being the fourth element, is to
be returned based on combination between the Look Up field and the
date range.

Can you please advise what Functions would work with this requirement.