intersect

Wizard intersect is the tool that searches for a table's intersections.
There are two cases with regard to intersections: exact matches and inexact matches.

Case 1: When there are exact matches:
Let us concentrate on the example to understand this function.
Let us use the following table:

After pressing the corresponding button of the toolbar, we will be able to see the Intersect dialogue box, where we will enter the data shown in the figure below:

Case 2: When there are inexact matches:
Let us concentrate on the example to understand this function.
Let us use the following table:

After pressing the corresponding button of the toolbar, we will be able to see the Intersect dialogue box, where we will enter the data shown in the figure below:

Finally, we press the OK button.
You can appreciate the results in the below figure. Note that it is the result of an intelligent combination of formulas.