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

Vlookup Approximate Match in Excel What does it do? Searches for an approximate value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) Wha...
RANDBETWEEN Function I use the RANDBETWEEN function all the time whenever I need to create a sample data set. The cool thing about the RANDBETWEEN function is that if you don't like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downl...
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 ...
IF Function Combined With The AND Function When combining (or nesting) the AND function with the IF function, it allows you to add more than one condition to your formula, something that is not possible with the IF function by itself. So you can show the results of Sales Reps that have made more than $3,000 of sales AN...