Support Board
Date/Time: Wed, 26 Feb 2025 11:44:09 +0000
Lookup function in spreadsheets
View Count: 896
| [2021-01-20 09:02:34] |
| User261741 - Posts: 22 |
|
Hi! Just to check, spreadsheet lookup function is no longer supported? Do you plan to implement it again any time soon? Thanks in advance... |
| [2021-01-20 14:02:03] |
| |
|
There have been no changes with spreadsheet functionality in years. Specifically what function are you referring to?
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 |
| [2021-01-20 16:47:11] |
| User261741 - Posts: 22 |
|
LOOKUP function. I saw that this was supported previously, now there is only VLOOKUP and HLOOKUP... I can mwork it around with couple of auxiliary columns to replicate LOOKUP, but I am already using all 60 columns for formulas. I need it to simply find first and last occurence of specific value in a range... |
| [2021-01-21 00:00:28] |
| |
|
Ok this was only in old spreadsheets which were discontinued years ago. The available functions are documented here: Spreadsheet Functions 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 Date Time Of Last Edit: 2021-01-21 00:00:43
|
| [2021-05-19 21:39:55] |
| j4ytr4der_ - Posts: 946 |
|
I came here also looking for the plain LOOKUP() function, as I need to find the *last* occurrence of a value in a VLOOKUP, not the first. I know there are other ways to get the result but was hoping to simply use this function.
Date Time Of Last Edit: 2021-05-19 21:40:07
|
| [2021-05-19 21:42:28] |
| j4ytr4der_ - Posts: 946 |
|
Actually it looks like GetCorrespondingMatch() is the preferred approach now, I will give that a shot.
|
To post a message in this thread, you need to log in with your Sierra Chart account: