Support Board
Date/Time: Sun, 22 Dec 2024 06:05:02 +0000
Post From: New Spreadsheets INDEX function
| [2014-11-21 14:25:30] |
| Sawtooth - Posts: 4141 |
|
This is disappointing. I extensively use INDEX in this way. I offered a simple formula as an example. [There is another way to do it that works:=AVERAGE(OFFSET(E3,0,0,$K$1,1))] But more complex uses of INDEX cannot be easily replicated with other functions, if at all. I also use the INDEX,MATCH combination extensively, like this simple example: =INDEX(E3:E1002,MATCH(K3-1,K3:K1002,-1),1) =MATCH(K3-1,K3:K1002,-1) works by itself, so it seems to be an issue with INDEX. Why does the INDEX,MATCH combination give a #REF! error in scss but not in scwbf? |