Date using index/collect if between X and Y on another sheet

cghallo_WBD

Hello, Community! I'm trying to pull in the Return_Date value from the Dates sheet where the Earnings End Date on the Additional Pay sheet is between the Start and End date ranges on the Dates sheet but am getting an #INCORRECT ARGUMENT SET error and not sure why. Any thoughts or alternatives? Thanks, all!

Jason Tarpinian

Looks like your COLLECT criterion and ranges and flip-flopped. Should be

=INDEX(COLLECT({Return_Date}, {Start}, <= [Earnings End Date @row], {End}, >= [Earnings End Date]@row),1)