Forum Discussion
Getting values from the same cell address in different spreadsheets
What do you mean by 'structured data'. Are they Excel Tables?
If so you can use INDIRECT to return a column of the table based upon the name of the table concatenated with the column reference. That way if a table appears in a different place, is a different size or the columns are in a different order, it makes no difference. An example might be
= INDIRECT(@Tables&"[Date]")
where @Tables is a relative reference to a particular member of a list of Tables and [Date] is a field found within the table.
The data are in different tabs (sheets) in my Excel workbook and sometimes they are at different cell addresses.
I'm not familiar with Excel Tables. Can you explain a bit further?
That same educational resource I sent you to earlier for info on INDIRECT can help you with questions like this on the nature of Excel Tables. https://exceljet.net/excel-tables
Spend some time there. Another good resource for getting more acquainted withe Excel is YouTube.
