Thanks guys. It appears the INDIRECT function is best suited for this. Most of my reference are nested if statements, thus the INDEX function just makes the formula longer and more confusing.