Support Board
Date/Time: Sat, 10 May 2025 01:30:52 +0000
Post From: Excel error & GetCorrespondingMatch multiple criteria selection
| [2018-03-25 19:38:50] |
| Bedhog - Posts: 182 |
|
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 |