Chip Pearson's site has a formula to do the opposite, but I didn't have any
luck rearranging the formula . . .

I have a calendar with each day of the year in a 7 X 2 array with the date
in the upper left cell. I am trying to match the day to an r X 2 worksheet
where I have "Date" and "Employee Name" and return the employees' names that
match the day. An employee's name will not occur twice on the same date,
however the number of employees per date will vary, but will not exceed 12.
Additionally, I would like to use a dynamic name range for the r X 2
worksheet so it can be amended anytime.

Any thoughts, comments, or suggestions are greatly appreciated. Thanks in
advance.