Page 1 of 1

Stifunction vlookup - Error messages

Posted: Wed Jun 11, 2025 3:17 pm
by MKA
Dear

In an incident report I have two data sources:
* A json file with information of a particular incident (for ex incident code)
* Several master data tables with codes and descriptions

On my report, I would like to lookup the description of a specific code in the masterdata table and print it on the report.
I'm trying to do it with a StiFunction directly in a text field, but getting error messages. Can you please let me know what I'm doing wrong?

Are there better ways to do it without using a relation?

Best regards
Manuel

Re: Stifunction vlookup - Error messages

Posted: Wed Jun 11, 2025 9:11 pm
by Lech Kulikowski
Hello,

Please check the correct arguments for the VLookup function.

Thank you.

Re: Stifunction vlookup - Error messages

Posted: Thu Jun 12, 2025 7:00 am
by MKA
Dear Lech

Thank you very much, it works finally!

Re: Stifunction vlookup - Error messages

Posted: Thu Jun 12, 2025 11:55 am
by Lech Kulikowski
Hello,

You are welcome.