Matching, lookup, or returning rows based on date

[IscariotPaladin]

Hello, I fairly new here this is the first time that I have ever posted on the forum but have visited here for other information that i have stumbled across. Hopefully, someone can help me figure out how to do it or tell me that it's not possible. I work as a case manager and I am trying to create a formula that pulls data from another sheet where it looks for the first 10 dates that will always be today and returns the data in that row. The column that I want to reference may contact older closed out cases and current open cases that the next contact date is in the future.

 

[alansidman]

Re: hello everyone I have a question about matching, lookup, or returning rows based on date

Can you show us an example of your data and what you want the results to look like. Do not need lots of data. Several records that need to be transformed and several that don't.