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.

DOWNLOAD WORKBOOK

Match - Intro

HELPFUL RESOURCE:

hmb_logo_01Lg

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Jump To A Cell Reference Within An Excel Formula When writing, editing or auditing Excel formulas you will come across a scenario where you want to view and access the referenced cells within a formula argument.This is helpful if you want to check how the formula works or to make any changes to the formula.There is ...
Excel Subtotal Function – Avoid Double Count... What does it do?It returns a Subtotal in a list or databaseFormula breakdown:=SUBTOTAL(function_num, ref1)What it means:=SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data)***Go to the bottom...
SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...
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...