Thread: Array Functions
View Single Post
  #8   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Harlan Grove" wrote...
....
INDEX has odd semantics in array formulas. Unlike OFFSET, INDEX will
only return arrays when either its first or second argument is zero.

....

Oops! Make that second or third argument is zero.