match formula

  • Thread starter Thread starter donny
  • Start date Start date
D

donny

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
 
Back
Top