Forum Discussion
Excel Formula Help
I have a client who uses excel for their business. It has multiple worksheets involved in one document. Not all worksheets are utilized.
If they hide a worksheet the formula does not work.
the formula that they are using is
=@P2.2!K3:L3
Can the formula be rewritten to accommodate the worksheets that are not used?
Eg they use P1.2, P1.3 and miss P1.4 and go to P2.1 what formula can they use so that it takes that last value available
thank you
David
1 Reply
Using structured references with Excel tables
#This Row
or
@
or
@[Column Name]
Just the cells in the same row as the formula. These specifiers can’t be combined with any other special item specifiers. Use them to force implicit intersection behavior for the reference or to override implicit intersection behavior and refer to single values from a column.
Excel automatically changes #This Row specifiers to the shorter @ specifier in tables that have more than one row of data. But if your table has only one row, Excel doesn’t replace the #This Row specifier, which may cause unexpected calculation results when you add more rows. To avoid calculation problems, make sure you enter multiple rows in your table before you enter any structured reference formulas.
