Hi Michelle

No, it has more to do with the nature of the question and the ease of which
an answer can be implemented.

What you have asked for is (IMHO) not an easy thing to achieve - especially
as you have the possibility of multiple people being entered into one cell
.... so I, and probably quite a few others, didn't attempt your question,
leaving it for someone who might actually know how to do what you have asked
in an easy and efficient manner.

From my reading of the question the only way to achieve what you want is via
the use of VBA code ... however, i can't visualise an easy solution here
either ... only a brute force, check every cell, every time something
changes type solution.

Hoping someone else can give you a better answer.

Regards
JulieD

"Michelle Tucker" wrote in
message ...
I have 2 excel sheets in the same workbook.
The first one has a rota on it. It is arranged in weeks, with Monday to
Sunday running along the top, and the name of the department running down
the
left hand side. At the bottom I have added a row for "holiday".
The second sheet is a holiday sheet. The names of the staff run along the
top of the sheet, with each cell underneath their name representing a days
holiday. Each cell is numbered so that we can see how many days they have,
and how many days they have left.
What I want to happen is to type the date of the holiday in the cell on
the
holiday sheet. This is the clever bit that I don't know how to do...
I want a formula in the holiday row in the rota sheet which looks for the
date at the top of the column. If it finds that date on the holiday sheet,
it
then puts the name of the person in the box. However, there may be lots of
people on holiday on the same day, so it would have to be able to list
them
(eg Michelle/Dave/Ian etc)
Possible?
--
Michelle Tucker