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 sheet #2.  There are 25,000+ rows that I'd like to compare and replace.  Does anyone know how to do this?  Thanks for your help!

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 03, 2023
      Thanks for your reply! What would I add to the formula to take the "Value" from Sheet 2 Column C (if it matches) and put it into Sheet 1 Column F? Thanks again!

Resources