I need to compare 2 tables with 2 columns in each. I need for it to pull back the ones in red below. I am dealing with thousands of numbers so I need it to pull them out for me. I can't scroll down and look for them. Example: TABLE 1 A BA1B1A2B2A3B3A4B4A5B5A6B6A7B7A8B8A9B9A10B10A11B11A12B12A13B13A14B14A15B15A16B16A17B17A18B18A19B19A20B20A21B21A22B22A23B23A24B24A25B25A26B26 TABLE 2 A BA1B1A2B2A3B3A4S7A5B5A6B6A7B7A8B8A9BXA10B10A11B11A12B12A13B13A14B14A15B15A16B16A17B17A18B18A19B19A20CXA21B21A22B22A23B23A24B24A25B25A26R78

HiAdd in each table anID column with the concatenation of the two columns:IDTABLE1 = Table1[A] & Table1[B]IDTABLE2 = Table2[A] & Table2[B]Then use the same formula as I said but replace the A column by the ID columns.Valid = IF(Table1[IDTABLE1] = LOOKUPVALUE (Table2[IDTABLE2], Table2[IDTABLE1], Table1[IDTABLE1]),"OK"," NOT OK")RegardsMfelix

Comparing 2 tables that have 2 columns each and return difference

Forum Discussion

Related content

Compare two columns in different tables

Comparing Difference between two columns in two different tables

DAX or Query: Compare two columns in different Tables

Compare different tables

Compare two date columns from different tables