Forum Discussion

robywoo's avatar
robywoo
Copper Contributor
Jun 19, 2022
Solved

INDEX MATCH Comparison

I need to determine whether or not data in one column matches data in another of a different workbook. If it does not match then I would like the result to be corresponding data not a "yes" or "no". ...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 19, 2022

    robywoo I would personally favour a helper column to determine the value from Sheet2 and then check it against the value in Sheet1, but you could do an "All-in-one" formula, but it repeats the INDEX/MATCH part.

    See attached.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 19, 2022

robywoo I would personally favour a helper column to determine the value from Sheet2 and then check it against the value in Sheet1, but you could do an "All-in-one" formula, but it repeats the INDEX/MATCH part.

See attached.