The CELL() function allows one to construct a reference from a target cell, like:
will return the string
Other functions, like OFFSET() and more, expect a cell reference as one of their arguments.
How can I tell the function to use the current cell's reference as an input? Something in the spirit of:
=CELL("ADDRESS", @) =CELL("ADDRESS",)