Extracting Common Values from Two Lists

An Excel file that teaches how to perform Extracting Common Values from Two Lists operation.

Excel Dashboard for Extracting Common Values From Two Lists

In the worksheet, two separate columns consisting of fruit names are prepared under the headings List 1 and List 2, and the values ​​in each list are written one by one into the cell ranges. To find common values, the FILTER function filters the List 1 range, and as a filtering criterion, the XMATCH function checks whether the values ​​of List 1 are included in List 2. The location information returned by XMATCH is number checked with ISNUMBER and only matching items are listed in the Common column as a result of the filter. Thus, all values ​​that intersect between the two lists are dynamically removed and a common result list is obtained.

Hope it is useful.