Support Board
Date/Time: Sun, 19 Jan 2025 08:57:41 +0000
Post From: Excel error & GetCorrespondingMatch multiple criteria selection
| [2018-03-25 19:38:50] |
| Bedhog - Posts: 179 |
|
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 |