• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

MATCH Function

The MATCH function returns the position of an item within a range of cells

The syntax for the MATCH function is:

=MATCH(lookup_value, lookup_array, [match_type])

ArgumentPurpose
lookup_valueThe value you want to search for in the lookup_array
lookup_arrayThe range of of cells that contains the lookup_value you are searching for
match_typeHow to match the lookup_value with values in the lookup_array. Can be entered as -1, 0 or 1 and is optional. If omitted Excel assumes match_type to be 11 – Finds the largest value less than or equal to the lookup_value. The range of cells should be sorted in ascending order. 0 – Finds the first value equal to the lookup_value-1 – Finds the smallest value that is larger than or equal to the lookup_value. The range of cells should be sorted in descending order

The example below demonstrates the MATCH function being used to find the position of James in the list.

Excel MATCH function returns the position of a value

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·