Support Board
Date/Time: Thu, 23 Jan 2025 04:54:10 +0000
Post From: I'm not able to make GETCORRESPONDINGMATCH spreadsheet function to works
| [2018-11-06 03:52:44] |
| Sawtooth - Posts: 4162 |
|
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. |