excel Intersecting names

Excel has a special operator called the intersection operator that comes into play when you’re
dealing with ranges. This operator is a space character. Using names with the intersection operator makes creating meaningful formulas very easy. For this example, refer to Figure 3-2. If you
enter the following formula into a cell
=Qtr_2 South
the result is 7,015 — the intersection of the Qtr_2 range and the South range.