MATCH function

Excel » Functions » Lookup and reference » MATCH function »

Match a range value containing both text and numerical characters

This article demonstrates how to match a value containing both text and digits to ranges. The search value is specified […]

Match two columns

This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]

How to use the MATCH function

Identify the position of a value in an array.

Extract table headers based on a condition

This article demonstrates an array formula that returns the table header based on a condition. For example, in cell C8 […]