Forum Discussion
Compare or search one data table in another table in Excel
Hi, We have two data tables in Excel that have a foreign key (a common field with the same data type). We want to search for the existence of data from the first table in the second table and identify if there are any inconsistencies in this comparison of the two tables. It should also display the found data separately. What method do you suggest?
tnx
1 Reply
XLOOKUP(), FILTER() with VSTACK()/HSTACK() may help. Attach a sample file with input data and showing your desired output. You may also share sample file via OneDrive, Google-Drive, Dropbox or similar services.
