For example, let's say that A1 is referencing B1. Thus, the formula in A1 is ="B1". I would like to have A2 return the referenced cell of A1, namely A2 ="B1". I don't know if INDIRECT or ADDRESS are helpful (just discovered them today), but I would appreciate some help in trying to figure out a way to do this! Thanks!
Bookmarks