match formula

I want to create a match formula, I want the formula to
look in column A AND B where numeric values are placed and
look in cells j1 AND J3 because i have a date range
there, J1 AND J3 looks like this 09/15/03 thru 09/16/03.
if there is a match with the vaules in column A AND B and
if the dates in column C are between the values of J1 AND
J3 then I would like a true value to return if not then
false. Hope I was clear, thanks

I *think* I understand. Try:

=IF(SUM((A1:A10=B1:B10)*(C1:C10=J1)*(C1:C10=J3)) 0,TRUE)

Array-entered (press ctrl/shift/enter for it to work).

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to create a match formula, I want the formula to
look in column A AND B where numeric values are placed
and
look in cells j1 AND J3 because i have a date range
there, J1 AND J3 looks like this 09/15/03 thru 09/16/03.
if there is a match with the vaules in column A AND B and
if the dates in column C are between the values of J1 AND
J3 then I would like a true value to return if not then
false. Hope I was clear, thanks
.

Well the values dont have to be on the same row with each
other there can be a value of 1000344 in A1 and the same
value in B4,. The date though will be on the same row for
example see below I changed it a bit so I can be a bit
clearer.

worksheet 3 (Date range)

J1 K1 L1
09/04/03 THRU 09/06/03

----------------------------------------------------------
worksheet 1 | WORKSHEET 2
A C | A C D
1000369 09/05/03 | 1000355 09/02/03 FALSE
1000344 09/08/03 | 1000369 09/05/03 TRUE
1000355 09/07/03 | 1000377 09/05/03 FALSE
1000377 09/10/03 | 1000344 09/08/03 FALSE


As you can see the formula will placed in column D on
worksheet 2. If the the numeric value anywhere in column A
match for both worksheets and the dates fall between the
dates that are in cell J1 AND L1 on worksheet 3 then a
value of true will be returned. I know this is different
than what I askedand I am truly sorry for not explaning
myself better.


-----Original Message-----
I *think* I understand. Try:

=IF(SUM((A1:A10=B1:B10)*(C1:C10=J1)*(C1:C10=J3) )0,TRUE)

Array-entered (press ctrl/shift/enter for it to work).

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to create a match formula, I want the formula to
look in column A AND B where numeric values are placed
and
look in cells j1 AND J3 because i have a date range
there, J1 AND J3 looks like this 09/15/03 thru
09/16/03.
if there is a match with the vaules in column A AND B
and
if the dates in column C are between the values of J1
AND
J3 then I would like a true value to return if not then
false. Hope I was clear, thanks
.

.

I'm not sure I understand this but I think you're saying that if column a =
column b and the date in column C is within the range shown by dates in J1
and J3, TRUE; otherwise, FALSE. If so, try something like this:

=AND(A1=B1,C1=$J$1,C1$J$3)

HTH

-Dave

"donny" wrote in message
...
I want to create a match formula, I want the formula to
look in column A AND B where numeric values are placed and
look in cells j1 AND J3 because i have a date range
there, J1 AND J3 looks like this 09/15/03 thru 09/16/03.
if there is a match with the vaules in column A AND B and
if the dates in column C are between the values of J1 AND
J3 then I would like a true value to return if not then
false. Hope I was clear, thanks