Fetching the Intersecting Cell Value

An Excel file that teaches how to perform Fetching the Intersecting Cell Value operation.

Excel Format: Fetching the Intersecting Cell Value

Row and column names are selected using validation lists. INDEX and MATCH are used together. Unfound items are directed to a blank value. Labels are automatically formatted. The result area is displayed in a single cell.

Hope it is useful.