I want to display the contents of cell B5 in A7 by using cell C7 to show the location of the cell to be displayed. Cell C7 has a formula that shows the cell location of information (text) that needs to be displayed. How can I show in A7 the contents of cell reference shown in C7? In figure attached I show an example to better understand.
Want in A7 to show the contents of B5 by reading what is in C7. So A7 cell should show word Road.
Thanks,
Bookmarks