Reply To: Comparing sheet data

Inner Circle › Ask Smartsheet Guru Crew Anything › Comparing sheet data › Reply To: Comparing sheet data

June 18, 2025 at 11:40 am #649
Peggy Parchert
Participant

    Hi Tamarin –

    I use an INDEX/MATCH Formula to do this – Michael is too fast 🙂 and said just what I was going to.

    I have a helper column in my EMS Lab Profile sheet (good sheet) that contains the formula:

    =IFERROR(IF(INDEX({Skillable: Lab Profiles ID}, MATCH([Lab Profile]@row, {Skillable: Lab Profiles Name}, 0)) = [Lab Profile ID]@row, “Yes”, “No Match”), “No Match”)

    I then have a report that only shows me those that are “No Match” so I can investigate.

    Peggy