Hi
Has the function "lookup" changed in this latest version.
I have downloaded the latest version, and now the =NL("Lookup") function does not work, it just returns "lookup" as a value in a cell.
Has this function changed, as its still appears in the function list??
Thanks
Andrew
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Andrew,
The NL(Lookup) formula is for report option lookups and for this purpose it works correctly. You may be incorrectly using NL(Lookup) when you should be using NL(First). Use NL(First) when you want the NL function to return a single value on your report. Use NL(Lookup) to create lookups on your options sheet which will be available on the Report Options window when the report runs. Does that make sense?
Regards,
Hughes
Please sign in to leave a comment.