0

NL("Lookup") - Having Multiple Columns

Did you know that you can create a lookup for your filters options in Jet Reports by using the NL("Lookup")?

You do this by putting the fields your want in your lookup in an Excel Array.

For Example;

=NL("Lookup","Customer",{"No.","Name"})

will create a 2 column lookup with "No." and "Name"

=NL("Lookup","Customer",C3:C4)

will create a 2 column lookup with whatever field names are in Cell C3 & C4

0 comments

Please sign in to leave a comment.