THis sounds like a use for a pivot table.

"tim" wrote in message
...

I have a work schedule that has a seperate sheet for different types of
scheduled time off Vacation time by weeks, Vacation time by days,
Personal time by days and so on. I would like to add a new sheet that I
could just key in the week ending date and i would get who will be off.
Column A on all sheets have the dates and i would want to bring back
the info in column B from each sheet. The problem is I have only used
VLOOKUP and I would be bring back up to 10 entries from each sheet. Is
something like this actually possible?


--
tim