=IF(ISNA(MATCH(1,(Others!W$5:W$15<=A4)*(Others!X$5 :X$15=A4),0)),"",INDEX(Others!V$5:V$15,MATCH(1,(O thers!W$5:W$15<=A4)*(Others!X$5:X$15=A4),0)))

Thanks so much I was sure this would work and I still think it will. What I
get is #VALUE. I have changed the formatting to general instead of time and
it still doesn't work. I think its the format but not sure.

What does MATCH 1 mean?

Any suggestions. Thanks
--
LS Teacher


"T. Valko" wrote:

Try this...

Daily Sch

A2 = 7:30
A3 = 7:35
A4 = 7:40
etc
etc

Class refes to Others!A$2:A$5
Start refers to Others!B$2:B$5
End refers to Others!C$2:C$5

Enter this array formula** in Daily Sch B2:

=IF(ISNA(MATCH(1,(Start<=A2)*(End=A2),0)),"",INDE X(Class,MATCH(1,(Start<=A2)*(End=A2),0)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Copy down as needed.

--
Biff
Microsoft Excel MVP


"LS" wrote in message
...
I have two sheets one named Daily Sch and Others. I am using Excel 2003.

Daily Sch
Others
A B A
B C
Time Class Class
Start End
7:30 (formula) Literacy
8:15 10:10
7:35 (formula) Math
11:00 11:55
7:40 (formula) Lunch
10:15 10:40
7:45 (formula) Science
7:30 8:10

Times continue on down on Daily Sch A. The formula should be placed in
Daily Sch B. Lookup the time in Others B and if it finds it should place
the
name of the class in Daily Sch B. If time not found leave Daily Sch B
blank.
Formula will have to look between start and end times.

If the times on Others is also a formula from another sheet will that also
make a difference? Is this impossible?
--
LS Teacher