Support Board

Date/Time: Sat, 11 May 2024 11:50:37 +0000

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

[2018-11-06 03:52:44] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3995
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.