We are trying to achieve to correctly display the "Real" cell address of a inquired cell. Then use that value to display the cells actual contents. Unfortunate, we have not been successful.
To best illustrate, in the attached excel you will find that "joe" is located at cell 'B4
' but the "Address" function used display '$A$4'. Also the function to display the contents cell in 'E6
' is not working correctly.
Please advice on the best way to accomplish this?