Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 06:04:14 +0000



Post From: New Spreadsheets INDEX function

[2014-11-21 18:26:29]
Sierra Chart Engineering - Posts: 104368

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?
We will look into this.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing