Passes to the Clio Cloud Conference are $99. Invest in your firm's success today.

How to Use Match Function on Excel

Question:

  • How to use the Match function on Excel
  • How to find the position of a value

Environment:

  • Excel

Additional Information:

  • For more information click here
  • MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. It returns a row a number representing its position

Answer:

  • Syntax: =MATCH (lookup_value, lookup_array, [match_type])
  • Lookup_value: is the value you want to search
  • Lookup_array: the array (column or row) you want to find the lookup_value in
  • Match_type: optional, use 0 for exact match,1 for exact or the next smallest (default), -1 = exact or next largest.

 

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality