Formula to copy one cell to another based on a ref cell

New Contributor

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 columns. The picture below explains much better what I am trying to do. I have over 60k row so I need a formula to copy the reference cells values instead of doing a manual =(reference cell) like shown in red

 

NJTBKR_0-1655678703990.png

refcell.JPG

1 Reply

@NJTBKR 

=ADDRESS($AH2,COLUMN(V2),4,1)

This returns the address as shown in the picture below.

address.JPG

=INDIRECT(ADDRESS($AH2,COLUMN(V2),4,1))

With the INDIRECT function you can copy the data from the referenced cells.

address indirect.JPG