Im having trouble manipulating this formula and hope theres 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 Ive 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€�)?

Ive been lucky to get an initial response (thanks €œToppers€�) that works on
a test sheet but Im 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,Sheet1!B:B,0)))

Ive been changing it to:

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

THANKS!

--
6-West