fbpx

Excel Match: How To Master It (2019)

The Excel MATCH function What does it do? In brief summary, the Excel MATCH function looks for a given criteria in a selected range (vertically or horizontally) and returns the row or column number (within that range) where it appears.  The range can be sorted in descending, any or ascending order depending on what match type is used. Syntax explained =MATCH(lookup_value, lookup_array, [match type]) Useful for finding a row reference of an [...]