Forum Discussion
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...
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
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.