Hi John

As far as I can see you are only using 3 criteria on your Results page. You
don't seem to be using Assembly.
Anyway, I would first of all create some named ranges to make life simpler.
InsertNameDefine
Name Start Refers to =Sheet1!Y2:Y1000
Name Finish Refers to =Sheet2!AI2:AI1000
Name Cells Refers to =Sheet1!:X2:X1000
Name Assembly Refers to =Sheet1!P2:P1000

In cell B2 of your Results sheet enter
=SUMPRODUCT((Start=$A2)*(Finish(<=$A2)*(Cells=B$1 ))

Copy across and down as required

--
Regards
Roger Govier

"John_J" wrote in message
...
I got stuck after 2 criterias, can anyone help! I need a formula that
returns
1 if true and 0 if false in Sheet2!B2:Z1000 (filled/copied out). The
formula
shall return 1 if the assembly workcell is occupied on the dates in
Sheet2!A2:A1000, and 0 if not.

For the formula in Sheet2!B2:
Criteria1 and 2: Lookup value=Running dates Sheet2!A2 is between Lookup
range=Sheet1!Y2:Y1000 and Sheet2!AI2:AI1000
Criteria3: The text "Assembly". Lookup range Sheet1!P2:P1000.
Criteria4: The cell name Sheet2!$B$1. Lookup range Sheet1!:X2:X1000

I have read several of the MATCH INDEX threads on this forum, but I cant
get
tit to work with 4 criterias combined with the "between dates". Dates are
formated as dd.mm.yyyy. Text is formated as "General".

Sheet1: (Letters P, X, Y, AI are col. headings)
P X Y AI
Status code Cell name Start date Finish date
Assembly Cell1 01.10.2008 31.10.2008


Sheet2: (Results in B2 etc.)
A B C D
Running dates Cell1 Cell2 Cell3
30.09.2008 0 0 0
01.10.2008 1 0 0
02.10.2008 1 0 0

--
Thanks
John_J