Hi I need help filling out the highlighted column. The goal here is to fill out in Sheet 1, Column D "1st Agent To Call", with the closet date after column C "Task Date" by vlooking up to sheet 2 column H "Task Done At", with Column J "Criteria" has to be "inbound" or "outbound" The highlighted in Yellow is the correct answer as an example. I had asked a similar question and answer worked using query so need help to modify the query function here
