Support Board
Date/Time: Thu, 28 Nov 2024 03:39:06 +0000
VLOOKUP [ApproximateMatch] argument is broken
View Count: 263
| [2023-06-05 10:13:15] |
| User346098 - Posts: 40 |
|
the function formula is in cell M2 it should return the value in cell P4 I am passing the value from VLOOKUP to ROW() Function to see in what row the result is landing and it's landing on row 999999 Thanks. |
 Spreadsheet1.scss - Attached On 2023-06-05 10:10:26 UTC - Size: 403 B - 81 views Attachment Deleted. |
| [2023-06-05 14:10:16] |
| Sierra_Chart Engineering - Posts: 17199 |
|
We will be looking 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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-08 07:00:17] |
| Sierra_Chart Engineering - Posts: 17199 |
|
We will implement a solution for this. However, as a solution now, specify the exact rows of the range (such as N1:Q6). This should also be more efficient.
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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2023-06-08 07:00:40
|
To post a message in this thread, you need to log in with your Sierra Chart account: