If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
match formula
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 . |
#3
|
|||
|
|||
match formula
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 . . |
#4
|
|||
|
|||
match formula
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 |
Thread Tools | |
Display Modes | |
|
|