Excel cell references not updating when referenced cells are sorted.
- by Robert Kerr
There are two tables, each with 75 entries. Each entry in the 2nd table calls an entry in the first table a parent. One of my 2nd table columns contains the "Parent Price", referencing the Price column in the first table, such as "=E50".
Table 1
Id Price
1001 79.25
1002 8.99
1003 24.50
Table 2
Id Price Parent Price
2001 50.00 =B2
2002 2.81 =B3
2003 12.00 =B4
The problem is when I sort the first table, none of the second table's "Parent Price" references are updated, and still point to the =E50 cell, which is no longer the correct parent.
I don't want to have to name the cells if possible.
What style of formula do I enter in the parent price column so that they properly track the cells in the referenced table?
