Support Board
Date/Time: Thu, 09 Jan 2025 20:07:14 +0000
VLOOKUP
View Count: 1400
| [2016-08-09 04:27:08] |
| GC15 - Posts: 7 |
|
Is the VLOOKUP function supported with the new spreadsheets? When I use it for a very simple array it returns #REF in Sierra Chart however works fine in Excel. I'm on version 1450 and attached a basic example.
|
 Vlookup.png / V - Attached On 2016-08-09 04:26:17 UTC - Size: 16.29 KB - 292 views |
| [2016-08-09 05:10:01] |
| |
|
Yes it is supported. Refer to the documentation here to make sure you are using it properly as it is supported in Sierra Chart: Spreadsheet Functions If you still have difficulty, we would need to look into this more closely. 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 |
| [2016-08-09 15:33:40] |
| GC15 - Posts: 7 |
|
Thank you. I've read through the Spreadsheet Functions webpage and confident I'm using it properly. The same formulas/spreadsheets work in Excel and in Sierra Chart with the old spreadsheets. I've uploaded the spreadsheet I'm working on. Sheet one contains the VLOOKUP which is embedded in a longer formula under columns Q and R (same basic formula except for long vs short position) and sheet two contains the simple VLOOKUP from the screenshot above. Thanks again for your help and if I can give you anymore details, let me know. |
Private File Attachment Deleted. |
| [2016-08-09 18:26:53] |
| |
|
We are checking on this. Just give us about two days. 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 |
| [2016-08-11 00:57:01] |
| Jeffrey - Posts: 2194 |
|
I found the use of the Column argument is off by 1. You can try it out by subtracting 1 from the third argument, but this should be fixed soon. The fix will affect any existing uses of VLOOKUP and HLOOKUP.
|
| [2016-08-11 18:22:29] |
| GC15 - Posts: 7 |
|
Thank you! That seems to have corrected it. I'd suggest updating the description for the VLOOKUP and HLOOKUP on the Spreadsheet Functions page until it's fixed since this differs from the Excel and Old Spreadsheets VLOOKUP and HLOOKUP functions.
|
| [2016-08-11 18:27:22] |
| Jeffrey - Posts: 2194 |
|
This should be fixed in the next release, and the website documentation will be updated to make it clear how the functions work with this fix.
|
To post a message in this thread, you need to log in with your Sierra Chart account: