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




1 Reply



This returns the address as shown in the picture below.



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

address indirect.JPG