Support Board

Date/Time: Sat, 11 May 2024 09:43:16 +0000

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

[2018-11-05 18:53:30] Link To Thread - Link To Post [Go To First Post]
User345323 - Posts: 18
Dear SC, I'm trying to use =GETCORRESPONDINGMATCH() function to works with following example. My data are as in the attached image. My function is: =GETCORRESPONDINGMATCH(AB3:AB9,AC1,0,1,0,AA3:AA9,0) AB3:AB9 >>>>> SearchColumn = 4,6,4,2,4,2,4 AC1 >>>>> SearchValue = 2 0 >>>>> NearestOrExact = Exact 1 >>>>> SearchRangeOrderingFlag = Ascending 0 >>>>> SameValueResolution = Use lower numbered row index, but with 1 nothing change AA3:AA9 >>>>> ReturnResultColumn = 3,4,5,6,7,8,9 0 >>>>> ReturnResultRowOffset = No row offset For me result =2 is not correct. And why if AC1=4 I get #N/A ? What I'm doing wrong? Very simply, I want to search range AB3:AB9 for number 2 for example, and looking from bottom to top of range, get as result the correspondenting row, in this case row n° 8. Any help with alternative functions? Thank you


example.jpg / V - Attached On 2018-11-05 18:25:25 UTC - Size: 26.88 KB - 303 views