This is a fun little custom function that makes a best guess at the address of a place you give it.

Take a look at this sheet which has the custom function GET_ADDRESS() in B2 and gets the address of A2.