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 …