Forum Discussion

Dmattes's avatar
Dmattes
Copper Contributor
Jan 20, 2022

Structured References

I have a table that is referencing tables from multiple other sheets.  The first formula picks up the structured reference, but each row below that when I try to reference the table in the next sheet...
excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Jan 21, 2022

Hi Dmattes 

 

so if I understand correctly, you try to reference a formatted table from within another formatted table, right?

In my opinion it's very unlikely that this would work only in very rare occasions, e.g. if you refer to whole columns, but not just to single cells in the other table.

Maybe you can provide a sample file here or at least some screenshots of the several tables.

Dmattes's avatar
Dmattes
Copper Contributor
Jan 21, 2022

The first 2 rows pull the table (MREXP008) reference from the 1st tab in my file.  All others after that pull the cell reference from the other tabs.  Each tab is set up the same.  The next row should be pulling from table MREXP011

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Jan 21, 2022

    Hi Dmattes 

     

    it's like SergeiBaklan explained above. Structured reference expect a value in the same row as the current row. This might apply to the first to rows in your example, but probably not for the others.

Resources