Re: Match Function On Range, Not Row Or Col
Match only works with single column/single row ranges (as you have found). What would you like a formula like:
to return? Are you expecting a range reference eg like Z89 returned, or something else?