LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Adapting an array formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adapting MAX function nir020 Excel Worksheet Functions 4 September 25th 06 04:53 PM
Multi line merged cell - adapting to different size input - possible? David Smithz Excel Discussion (Misc queries) 1 June 18th 06 04:21 PM
Help needed with Adapting complex INDEX formula sonar Excel Worksheet Functions 2 August 27th 05 01:40 PM
Adapting some code chrisrowe_cr[_6_] Excel Programming 4 August 16th 05 01:18 PM
adapting the findnext function chrisrowe_cr[_3_] Excel Programming 7 August 2nd 05 05:24 PM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"