Support Board
Date/Time: Sat, 23 Nov 2024 02:14:14 +0000
Post From: Spreadsheet Study: GetCorrespondingMatch help. #NUM!
| [2024-09-24 23:12:11] |
| C_Money - Posts: 64 |
|
Hello! In my spreadsheet study. I am trying to find the first instance of a 2 or a 3 from O3 to P1000. I just want the most recent value in either column. If true, then I want the following IF(AND statement to be evaluated: =IF(OR(
GetCorrespondingMatch(O3:P1000, 2, 0, 0, 0, O3:P1000, 0), GetCorrespondingMatch(O3:P1000, 3, 0, 0, 0, O3:P1000, 0) ), IF(AND( ID0.SG4@3 > (ID41.SG1@3 - 2), ID0.SG4@3 > ID43.SG1@3, ID0.SG4@3 > (ID42.SG1@3 - 3), CROSSFROMBELOW(ID10.SG1@3:ID10.SG1@4, ID10.SG6@3:ID10.SG6@4) ), ID0.SG3@3 - 3, 0), 0) Unfortunately this is throwing a #NUM! error in every cell all the way down column AC where I have the formula entered. |