Forum Discussion
maintaining a cell reference despite changing the cell location through sorting
if the position of a value is changed through a sorting procedure the reference to the value in another cell is lost... e.g.: I reference cell A1 filled with the value 1 to which I reference in anoth...
Filters do not follow the rules of maintaining cell references. The function =A1 references the cell A1 not the value in A1. What I mean by this is that when you filter your table, =A1 will always refer to whatever value is held in cell A1, not the value that was originally in cell A1 before the filter was initiated. If your table permits it, VLOOKUP() may be a viable solution to your problem.
PReagan: thanks, but you repeat just the problem (which I have already understood). I'm looking for the solution... ;-)
ps: and I was not talking about filtering (which is even more tricky); I was talking about sorting...