Actually, Cutter's formula using INDEX although confusing turned out to be better. With INDIRECT I kept on getting prompts to save the file when there weren't any changes. I guess this is what is meant by volatile. Thanks again for the help guys!
Edit: How do I mark a thread as solved?
Bookmarks