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 identif...
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.