Friday, February 16, 2024
This function is only available for Sage 50 Canadian Edition
This function returns the indices corresponding to the requested criteria.
Database table from which the data will come.
Column to search.
Value to lookup.
Custom dataset to use.
Sage 50 Connection to query. If left empty, the default connection will be used.
It is strongly recommended to use Excel cells address (ex. A1:B19) containing the information of the parameters requested in all XLGL functions, such as: names or codes. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.
You can Contact us so we can address your question.