I’m having trouble manipulating this formula and hope there’s an answer out
there:

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,Sheet1!B:B,0)))

I’ve been changing it to:

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

THANKS!

--
6-West