#VALUE! Error Help

Originally Posted by 6StringJazzer

Somehow I was thinking it was going to use the contents of the cell to return a column reference for another cell

I must admit that when I saw your comment and then the formula with the ADDRESS function, I initially went, "yeah, that would do it" before my brain did a double take.