I'm sure this will be helpful to me someday, but in the file that I am
currently working with, I am receiving #REF errors everywhere when using
VLOOKUP. It is far to time consuming to edit two sheets of data. It is even
more time consuming to look through math equations to figure out if all the
results are still correct or not.

There has to be something that lock data with cells and allows for easy
sorting. Like in Access (though a completely different program) all data in a
row is locked. You sort the list all the data moves along with its correct
pairing.

"Sheeloo" wrote:

If you use VLOOKUP then..

Whatever changes you do in Column 2 of sheet 2 (Lookup sheet) will
automatically show up in Col 2 of Sheet 1
Also if you change any cell in Col 1 of Sheet 1, Col 2 will also
automatically change by looking up the value in Sheet 2.
If you want to change 'Mouse is afraid of Cat' to 'Mouse is afraid of Dog'
then you just need to change Sheet 2 (change value agains Mouse to Dog from
Cat)..

Try it with few samples ... it will give you what you want.