0
Thanks

A few words of thanks would be greatly appreciated.

Excel - The MATCH function

Search functions and matrices: MATCH


Description : Displays the position of an element in a matrix.

  • Syntax : Match( value, array, type )
  • Value is the value that you want to search in the array.
  • Array is the cell range
  • Type: -1, 0 or 1.
    • 1: The MATCH function returns a value less than or equal to the value
    • 0: The MATCH function returns an identical value
    • -1: The MATCH function returns a value greater than or equal to the value
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - The MATCH function », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).