MATCH function

Excel » Functions » Lookup and reference » MATCH function »

Match a range value containing both text and numerical characters

Formula in cell C11: =LOOKUP(MID(C10, 4, 999)*1, MID(B3:B8, 4, 999)*1, D3:D8) This formula is an array formula.┬áTo enter an array […]

Match two columns

The array formula in cell D12 matches two values in two columns each and returns a value on the same […]

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 […]