Please don't talk about "2 criterias" and "4 criterias".
The singular is criterion, the plural is criteria.

Hopefully someone else can answer your question.
--
David Biddulph

"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