It is usually used by taking the result of one analysis (top product sales, most popular links) and filtering a detail report to see what contributed to the ranking.
Match with – select a worksheet or previously named table from the drop down list. The worksheet must be in the same workbook, and data must start in cell A1 and include a header row. If you want to use a table in memory, use Table Name to create the reference.
Select Key Columns – select columns that will be used to align the two tables together. All values from all selected columns must match for a row to match.
Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters.
Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (leading, trailing or within the text).
Keep matching rows – keep only rows that have matching rows in the reference table.
Remove matching rows – remove rows that have matching rows in the reference table.
Blog article: Using the Match Function