Hi, I have managed to get the lookup function to show me 2 or 3 fields if they are held in an Excel range, can this be done from a lookup into a NAV table.
=NL("Lookup",Range,Headers) works fine, where "Range" and "Headers" are two range names in Excel containing hand-crafted data.
Is there a way of specifying more than one field name in a NAV table to do something similar?
Clearly =NL("Lookup","Customer","No.,Name,PostCode") is not going to work.
Many thanks.
Rod
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Hi,
You are almost there…
quoting Clearly =NL("Lookup","Customer","No.,Name,PostCode") is not going to work
Try =NL("Lookup","Customer",{"No.","Name","Post Code"})
Regards
Tom -
Jet Reports Historic Posts This works fine when referring to an Excel range.
-
Jet Reports Historic Posts Wonderful, thanks. Just what I needed.
Please sign in to leave a comment.