0

Add column with company name to NL table function

Hi,

I'm using the NL table function to retrieve full table data from multiple companies in different sheets in excel:

=NL("Table";Parameters!C7;;"DataSource=";Datasource;"Company=";"X")

=NL("Table";Parameters!C7;;"DataSource=";Datasource;"Company=";"Y")

=NL("Table";Parameters!C7;;"DataSource=";Datasource;"Company=";"etc")

I need to retrieve the company name as an extra column to use in Pivots, anyone a clue how to fix this? 

 

 

1 comment

Please sign in to leave a comment.