Support Board
Date/Time: Tue, 01 Jul 2025 05:48:32 +0000
Post From: I'm not able to make GETCORRESPONDINGMATCH spreadsheet function to works
| [2018-11-06 03:52:44] |
| Sawtooth - Posts: 4231 |
|
Both the GETCORRESPONDINGMATCH function, and the INDEX/MATCH function combination, return the value in the cell, not the row # where that value is located. If you want to return the row # of the furthest matching value, use the MATCH function in a formula like this: =MATCH($AC$1,AB3:AB9,1)+2 If you want to return the row # of the nearest matching value, use the MATCH function in a formula like this: =MATCH($AC$1,AB3:AB9,0)+2 The +2 is an offset to compensate for the first row being row 3. |