How do I make a named cell look to an address from a formula?

Originally Posted by Polymorpher

whats the benefit

Efficiency.

Indirect is a volatile function, meaning it recalculates every single time Anything in the book changes, regardless if that change is relevant to that function or not.

Plus, the binary search used by the MATCH function is leaps and bounds faster than AGGREGATE(14, 6, ROW('QV3'!C$3:C2000)/('QV3'!C$3:C2000<>""), 1)
And I mean really fast, like comparing a Turtle to a Cheetah faster.