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 it must include a header row. If you want to use a table in memory, use the Table Name function to create the reference.
Select Columns – select the columns that will be used to align the two tables together. All values from all of the 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 (applies to text columns only).
Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (applies to text columns only).
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
Updated for v10.