I have a sheet that consists of a column of dates (some repeated) and data
from that particular day. In a 2nd sheet are formatted listings of data for
each day.

In the 2nd sheet, I'm using vlookup to find the data for the first job for
each day. Is there a simple way to manipulate vlookup to return data
corresponding to the 2nd, 3rd, etc occurrence of the date that it is
searching for, or would another function be better suited?