Cell Reference

[JC]

I have created a formula to find the relative position of
a cell base on certain criteria. I have then used the
address function to create a cell reference. I want to
then insert this reference into a formula to calculate a
variance. The VAR function looks at the address formula
as a formula and not a reference. My attempts at making
this work have not gone well. Any suggestions?

 

[David Hager]

You can use the OFFSET function to return a reference based on your formula.

 

[Jerry]

Thanks, It took me a minute to figure it out but it works
beautifully.