• Dp

"MATCH" Function In Excel

Updated: May 2, 2019

This function looks for an item in a list and shows its position. It can be used with text and numbers. It can look for an exact match or an approximate match.


Syntax:

=MATCH(WhatToLookFor,WhereToLook,TypeOfMatch)


The Type Of Match  is either 0, 1 or -1.

0 will look for an exact match. If no match is found the #NA error will be shown.

1 will look for an exact match, or the next lowest number if no exact match exists.

 

If there is no match or next lowest number the error #NA is shown.

The list of values being examined must be sorted for this to work correctly.

-1 will look for an exact match, or the next highest number if no exact match exists.

If there is no exact match or next highest number the error #NA is shown.

The list must be sorted for this to work properly.


Example:



Here is the video tutorial of the same for clear understanding.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at dptutorials15@gmail.com

Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon