Support Board
Date/Time: Fri, 31 Oct 2025 22:25:00 +0000
Post From: I'm not able to make GETCORRESPONDINGMATCH spreadsheet function to works
| [2018-11-06 03:52:44] |
| Sawtooth - Posts: 4281 |
|
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. |