Forum Discussion

NJTBKR's avatar
NJTBKR
Copper Contributor
Jun 19, 2022

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 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

 

Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jun 19, 2022

    NJTBKR 

    =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.

     

     

Resources