how to reference tables on another sheet

[anders2010]

hey my question is how do you reference a table on another sheet so that when you sort that original table it doesn't change the reference you made on that other sheet.

i know how to do this when i am referencing a cell. for instance if i am referencing a cell on sheet 5 and that comes out to something like =Sheet5!B2, i know that when i sort the data differently in sheet 5, that reference will know to change to =Sheet5!B18 or where ever that original reference ends up in this new sorting. but if I do =Table5[2] or something, and i sort that table differently, the reference will change to the new data in that cell and will not follow old reference through the new sort.

[FDibbins]

Hi and welcome to the forum

Instead of using the structured table referencing, try to type in the formula manually