Excel - The MATCH function

August 2017


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



Related


Published by aakai1056. Latest update on November 9, 2011 at 10:56 AM by aakai1056.
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).