I have 2 workbooks. One contains a list of data ranges and the other one a
list of date. I would like to check for each date in my 2nd workbook if the
date is in the ranges listed in my f1st workbook.
Example of workbook 1:
1 1/1/2007 2/1/2007
2 3/1/2007 5/1/2007
3 9/1/2007 10/1/2007

Example of workbook 2:
1 1/15/2007
2 1/17/2007
3 9/19/2007

Result should look like this:
1 1/15/2007 1
2 1/17/2007 1
3 9/19/2007 3

Any ideas how I could achieve this?

Thanks

Try this one:
=sumproduct(('[workbook2]sheet1'!$A$1='[workbook1]sheet1'!$A$1:$A$3)*('[workbook2]sheet1'!$A$1='[workbook1]sheet1'!$B$1:$B$3))
with appropriate workbooks and worksheets names and ranges...

--
A+

V.


"Pierre" wrote:

I have 2 workbooks. One contains a list of data ranges and the other one a
list of date. I would like to check for each date in my 2nd workbook if the
date is in the ranges listed in my f1st workbook.
Example of workbook 1:
1 1/1/2007 2/1/2007
2 3/1/2007 5/1/2007
3 9/1/2007 10/1/2007

Example of workbook 2:
1 1/15/2007
2 1/17/2007
3 9/19/2007

Result should look like this:
1 1/15/2007 1
2 1/17/2007 1
3 9/19/2007 3

Any ideas how I could achieve this?

Thanks

sorry... this would be better:
=sumproduct(('[workbook2]sheet1'!$A1='[workbook1]sheet1'!$A$1:$A$3)*('[workbook2]sheet1'!$A1<='[workbook1]sheet1'!$B$1:$B$3))
--
A+

V.


"Vincnet." wrote:

Try this one:
=sumproduct(('[workbook2]sheet1'!$A$1='[workbook1]sheet1'!$A$1:$A$3)*('[workbook2]sheet1'!$A$1='[workbook1]sheet1'!$B$1:$B$3))
with appropriate workbooks and worksheets names and ranges...

--
A+

V.


"Pierre" wrote:

I have 2 workbooks. One contains a list of data ranges and the other one a
list of date. I would like to check for each date in my 2nd workbook if the
date is in the ranges listed in my f1st workbook.
Example of workbook 1:
1 1/1/2007 2/1/2007
2 3/1/2007 5/1/2007
3 9/1/2007 10/1/2007

Example of workbook 2:
1 1/15/2007
2 1/17/2007
3 9/19/2007

Result should look like this:
1 1/15/2007 1
2 1/17/2007 1
3 9/19/2007 3

Any ideas how I could achieve this?

Thanks

Thanks!
Pierre

"Vincnet." wrote:

sorry... this would be better:
=sumproduct(('[workbook2]sheet1'!$A1='[workbook1]sheet1'!$A$1:$A$3)*('[workbook2]sheet1'!$A1<='[workbook1]sheet1'!$B$1:$B$3))
--
A+

V.


"Vincnet." wrote:

Try this one:
=sumproduct(('[workbook2]sheet1'!$A$1='[workbook1]sheet1'!$A$1:$A$3)*('[workbook2]sheet1'!$A$1='[workbook1]sheet1'!$B$1:$B$3))
with appropriate workbooks and worksheets names and ranges...

--
A+

V.


"Pierre" wrote:

I have 2 workbooks. One contains a list of data ranges and the other one a
list of date. I would like to check for each date in my 2nd workbook if the
date is in the ranges listed in my f1st workbook.
Example of workbook 1:
1 1/1/2007 2/1/2007
2 3/1/2007 5/1/2007
3 9/1/2007 10/1/2007

Example of workbook 2:
1 1/15/2007
2 1/17/2007
3 9/19/2007

Result should look like this:
1 1/15/2007 1
2 1/17/2007 1
3 9/19/2007 3

Any ideas how I could achieve this?

Thanks