Forum Discussion
Formula to copy one cell to another based on a ref cell
Hello - I had 2 sets of coordinates that I needed to compare/match. I managed to get the reference of the matching cells but I need a way (formula) to copy the value of the ref cells into the new col...
=ADDRESS($AH2,COLUMN(V2),4,1)This returns the address as shown in the picture below.
=INDIRECT(ADDRESS($AH2,COLUMN(V2),4,1))With the INDIRECT function you can copy the data from the referenced cells.