Forum Discussion

nwmt48's avatar
nwmt48
Copper Contributor
Feb 03, 2023
Solved

Compare two sheets and replace values

Hi, I want to compare Column A of sheet #1 in a file to Column A of sheet #2 (same file different tab).  If it matches, then replace the value in Column F in Sheet #1 with the value in Column C of sh...
Excel
  • Rodrigo_'s avatar
    Rodrigo_
    Feb 04, 2023

    nwmt48 

    formula for cell F1 on sheet 1

    =IF($A1=Sheet2!$A1,Sheet2!$C1,"NOT MATCHED")

     This will bring the "VALUE" of Sheet 2 column C (if matches) on sheet 1 column F.

    sample file is on the attached.

Rodrigo_'s avatar
Rodrigo_
Steel Contributor
Feb 04, 2023

nwmt48 

formula for cell F1 on sheet 1

=IF($A1=Sheet2!$A1,Sheet2!$C1,"NOT MATCHED")

 This will bring the "VALUE" of Sheet 2 column C (if matches) on sheet 1 column F.

sample file is on the attached.

  • nwmt48's avatar
    nwmt48
    Copper Contributor
    Feb 04, 2023
    Thank you so much!

Resources