Adapting an array formula
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
|