title: Excel formula that returns address of current (active) cell
body: <p>I'm trying to write an Excel formula (no VBA please) that returns the address of the active cell, i.e., the cell where the cursor is currently. For example, I have a lookup function in cell A5 that refers to lookup table with, say, 3 rows and 2 columns and I need a formula as <code>=vlookup(activecell, A1:B3, 2, 0)</code> so that when I click on, say, cell A2, then the lookup formula in cell A5 would show the contents of cell B2. I can't seem to come upon what I should use for "activecell". I've tried combinations of <code>row()</code>, <code>address(row(), column())</code>, indirect, but I can't get the magic combination. Thanks in advance for any help!</p>