Support Board

Date/Time: Sat, 18 May 2024 06:22:19 +0000

Post From: Excel error & GetCorrespondingMatch multiple criteria selection

[2018-03-25 19:38:50] Link To Thread - Link To Post [Go To First Post]
Bedhog - Posts: 168
Hello Team, This function is working in Excel and I need a hand to make it work in the SC Spreadsheet. =INDEX(A1:A100, MATCH(TRUE, INDEX(A1:A100<$J$48, 0 ), ) ) I am looking to return the first value in ColumnA that is less than the value stored in $J$48 Excel returns 64.95 which is correct. SC is returning #VALUE!. $J$48 = 65.04 ColumnA 65.2 65.2 65.2 65.1 65.1 65.1 65.1 65.1 65.1 65.1 65.1 65.1 65.1 65.1 65.1 65.05 64.95 64.95 64.95 64.95 64.86 64.86 64.86 64.86 64.86