Range Lookup

[samsung92]

I am having problems doing a lookup of a range of dates.
I want to put a 1 or 0 if a date required can be found in a range of dates I have already.

 

[onlyadrafter]

Hello,

I think more detail is required.

 

[samsung92]

I am attempting to create a kind of look up across various ranges of dtaes to come back with either a 1 or 0 as the answer.

I have changed the dtaes into numbers but still this will not seem to work ?[/b]

 

[onlyadrafter]

Hello,

Can you supply a sample of data?

 

[dcartwright]

Try something like this below.

=IF(C2=A1:A3,1,0)

Cell C2 is the date you are looking up in my formula
and
column A1:A3 is the range of cells containing the dates

Hope this helps

 

[Gohar Shahab]

Book2
	A	B	C	D
1	31/12/2006
2	01/01/2007	02/01/2007
3	02/01/2007	1
4	03/01/2007
5	04/01/2007
6	05/01/2007
7	06/01/2007
8	07/01/2007
9	08/01/2007
10	09/01/2007
11	10/01/2007
12	11/01/2007
13	12/01/2007
Sheet1

 

[samsung92]

1000 days Base Year 1 2 3 4 5 6 7 8 9
Maintenance
Contract Start Date 05/06 06/07 07//08 08/09 09/10 10/11 11/12 12/13 13/14 14/15
30/10/2001 38991
01/11/2002 38992
30/04/2001 38993
01/09/2003 38994
01/09/2003 38995
01/09/2003 38996
01/09/2003 38997
01/09/2003 38998

 

[Gohar Shahab]

or you can use

Book2
	A	B	C	D
1	31/12/2006
2	01/01/2007	13/01/2007
3	02/01/2007	0
4	03/01/2007
5	04/01/2007
6	05/01/2007
7	06/01/2007
8	07/01/2007
9	08/01/2007
10	09/01/2007
11	10/01/2007
12	11/01/2007
13	12/01/2007
Sheet1