create a list from named cells from another excel file

[lcp]

Hi,

I would like to know if it's possible to do the following:

create a list based on a cell named "COMPANY_INDUSTRY". this named cell is in another excel file. In this file there will be several sheets with the "COMPANY_INDUSTRY" info. So the formula needs to look into the entire file and collect the ones that exist.

Thank you in advance

 

[ExcelGzh]

lcp

There are some things that aren't clear here

1. Are you making a list in 01.xlsx based on data on 02.xlsx or the other way around?

2. What is the data you're actually assembling? Company names? Your two workbooks have headings but no data.