Thanks, that seemed to work. The only other question I have is regarding
quarter hours:

I successfully copied the formula to the rest of the time slots on Sheet 2
("Printout") except that it doesn't seem to work with quarter hours (such as
"7:15","7:45") in that it doesn't "pull" those times over.

Is this a limitation of the formula?

Thanks again
--
6-West


"Bob Phillips" wrote:

Sorry, not an array formula, standard.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sixwest" wrote in message
...
I'm having trouble manipulating this formula and hope there's an answer
out
the

What I'm trying to do is to have a link between sheets but with
different data being propagated. Such as:

Sheet "A" (which I've called "Schedule") is the sheet with employee names
listed. Let's say
Employee "1" is listed in cell A8 and I input 9:30 AM in cell C8 (i.e.,
Employee "1" scheduled for 9:30).

Sheet "B" (called "Printout") is a list of the schedule times. If 9:30AM
is
displayed in cell A4 on "Printout", is there a way to automatically
propagate
"Employee 1" (from "Schedule" A8) into B4 when "9:30 AM" is input to C8
(in
"Schedule")?

I've been lucky to get an initial response (thanks "Toppers") that works
on
a test sheet but I'm unable to manipulate it to work with what I have:


=IF(ISNA(MATCH(A1,Sheet1!B:B,0)),"",INDEX(Sheet1!$ A$1:$A$1000,MATCH(A1,Sheet
1!B:B,0)))

I've been changing it to:


=IF(ISNA(MATCH(A8,Schedule!C:B,0)),"",INDEX(Schedu le$A$8:$A$1000,MATCH(A8,Sc
hedule!C:B,0)))

THANKS!

--
6-West