Thank you. Both posts helped a lot and both seem to work perfectly for the
example I posted. Are any of the functions used in those limited to how many
columns you can have and search through? As you may have guessed, the
example I gave is a simplified spreadsheet based on the one I am trying to
improve at work. The actual one has an employee name and serial number
assigned to them in the first two columns and then most of the columns to the
right are many different due dates for different types of things that are due
for that person for the serial number to which they are assigned. So Task A
might have a due date in column C as in the example I gave and say that
column D has a spot for the employees' initials when they finish Task A and
column E is the date they finished Task A. Column F then would be the due
dates for another task we'll call Task B. And columns G and H would be just
like D and E but for Task B. This pattern repeats for a few different types
of tasks that all must be done for a given serial number and the employee
assigned usually does each of these tasks.

With that said, the example second sheet I showed would be just like that
but with more rows, one row for each type of task showing the upcoming serial
and due date but for each task.

Will this be accomplished in the exact same way but with larger column ranges?

In the actual spreadsheet it has about 100 rows and columns A through AM or
so, so there is a lot of data there.

Thanks so much again for the help so far and I think it is almost exactly
what I need. Thanks to both posters too. Both suggestions helped a lot.