Table 1 has data, and Table 2 has formulas referencing data from Table 1. If
I sort the data in Table 1, the formulas in Table 2 end up referencing the
wrong cells. Is there a simple way to fix?

Thanks,

Mike

Don't use formulas like =sheet2!a1

I like to find a key field and populate them as values on the second table.
Then use =vlookup() or =index(match()) to retrieve the other stuff.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

mshulman wrote:

Table 1 has data, and Table 2 has formulas referencing data from Table 1. If
I sort the data in Table 1, the formulas in Table 2 end up referencing the
wrong cells. Is there a simple way to fix?

Thanks,

Mike

--

Dave Peterson

Thanks Dave, good idea--hadn't thought of that. Curious if anyone has other
ideas that might save time? I'm surprised Excel's Help feature doesn't seem
to address this. Seems like a simple and possibly common problem.

Mike

Dave Peterson wrote:
Don't use formulas like =sheet2!a1

I like to find a key field and populate them as values on the second table.
Then use =vlookup() or =index(match()) to retrieve the other stuff.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Table 1 has data, and Table 2 has formulas referencing data from Table 1. If
I sort the data in Table 1, the formulas in Table 2 end up referencing the
[quoted text clipped - 3 lines]

Mike