0

Nested NP function within an NL function

=NL(NP("Companies","AC Ltd"),"Lease",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","Lease","IncludeDuplicates=","True")

Three assumptions:
- You are trying to build an excel table object from the table 'Lease'
- The fields in the table are in $D$4:$E$4
- NP("Companies","AC Ltd") returns just ONE company name

If those are true, try
NL("Table","Lease",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","Lease","IncludeDuplicates=","True";"Company=";NP("Companies","AC Ltd"))
But the NP in the end ins't really necessary.
You can just put the company name in there.

HTH

rmw

2 comments

Please sign in to leave a comment.