Expand the MATCH function - allow range being searched to be 2-dimensional.
Expand the the MATCH function capability to allow the second argument to refer to a two-dimensional range, instead of restricting it to data in a single column or data in a single row.
Microsoft's documentation of the MATCH function (via Excel Help) does not mention this restriction but simply refers to the "range of cells being searched" as if it could be any range.
Kenneth Barber commented
MATCH returns only single number. It wouldn't make sense for it to work on a 2D range.
A.C. Wilson commented
Simialr issue when using SUMPRODUCT() for multiple condition tests (as described by Bob Phillips in http://www.xldynamic.com/source/xld.SUMPRODUCT.html).