Support Board

Date/Time: Fri, 03 May 2024 04:05:53 +0000

Post From: New Spreadsheets INDEX function

[2014-11-21 14:25:30] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3992
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?