The MATCH function in Excel returns the position of an item within a list or a range of cells.

Say that you have a Price List and want to know in which position a certain item is located within that Price List, then you would use the MATCH function.

Formula Breakdown: MATCH(lookup_value, lookup_array, [match_type])

What it means: MATCH(lookup this value,from this list or range of cells, return me the Exact Match)

NB: The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.


Match - Intro



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Return the Last Value in a Column with the Offset ... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...
INDIRECT Function in Excel What does it do?Returns a reference to a range. The referenced range can be a cell, a range of cells, or a named range.Formula breakdown:=INDIRECT(ref_text, )What it means:=INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FAL...
Vlookup in Multiple Excel Sheets What does it do?Searches for a value in the first column of a table array and returns a value in the same row from another sheet´s column (to the right) in the table array.Formula breakdown:=VLOOKUP(lookup_value, table_array, col_index_num, )What it means:=VLO...