Searching and Listing Common Values in Two Lists

Excel file teaching how to perform Searching and Listing Common Values in Two Lists operation.

Excel Template for Searching and Listing Common Values in Two Lists

Multiple criteria are applied simultaneously. Blank values are processed without errors. The formula structure is adapted to table references. Usage is reinforced with advanced examples. Result cells are automatically formatted.

Hope it is useful.