Range Lookup

samsung92

Board Regular
Joined
Sep 15, 2006
Messages
93
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.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

samsung92

Board Regular
Joined
Sep 15, 2006
Messages
93
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]
 

dcartwright

New Member
Joined
Feb 22, 2006
Messages
31

ADVERTISEMENT

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

Active Member
Joined
May 17, 2006
Messages
339
Book2
ABCD
131/12/2006
201/01/200702/01/2007
302/01/20071
403/01/2007
504/01/2007
605/01/2007
706/01/2007
807/01/2007
908/01/2007
1009/01/2007
1110/01/2007
1211/01/2007
1312/01/2007
Sheet1
 

samsung92

Board Regular
Joined
Sep 15, 2006
Messages
93
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

Active Member
Joined
May 17, 2006
Messages
339
or you can use
Book2
ABCD
131/12/2006
201/01/200713/01/2007
302/01/20070
403/01/2007
504/01/2007
605/01/2007
706/01/2007
807/01/2007
908/01/2007
1009/01/2007
1110/01/2007
1211/01/2007
1312/01/2007
Sheet1
 

Forum statistics

Threads
1,137,204
Messages
5,680,166
Members
419,887
Latest member
Vasokir

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top