Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In B4 of Printout
=IF(ISNA(MATCH(A4,Schedule!C:C,0)),"",INDEX(Schedu le!$A:$A,MATCH(A4,Schedule !C:C,0))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adapting MAX function | Excel Worksheet Functions | |||
Multi line merged cell - adapting to different size input - possible? | Excel Discussion (Misc queries) | |||
Help needed with Adapting complex INDEX formula | Excel Worksheet Functions | |||
Adapting some code | Excel Programming | |||
adapting the findnext function | Excel Programming |