Support Board

Date/Time: Sun, 12 May 2024 04:06:51 +0000

Post From: I'm not able to make GETCORRESPONDINGMATCH spreadsheet function to works

[2018-11-06 23:36:39] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3995
I don't know why =MATCH($AC$1,AB3:AB9,1)+2 doesn't see the 6. =NMATCH(1,$AC$1,AB3:AB9,0)+2 does see it. Have a look at the NMATCH function. You'll need a separate Formula Column for each use of the NMATCH. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#NMATCH_Function FYI, this formula returns the same as =MATCH($AC$1,AB3:AB9,0)+2 where the formula is in Q3: =IF(AB3=$AC$1,3,Q4+1) The 3 is the starting value to be incremented to compensate for the first row being row 3 (1+2=3). Also, look at this example of a way to sort the array in the opposite direction: https://www.sawtoothtrade.com/example-8.html You can modify this example to sort a portion of the array. Once the array is sorted in the opposite direction, you can use =MATCH($AC$1,AB3:AB9,0)+2 or =IF(AB3=$AC$1,3,Q4+1) which does see the 6.