hello friends its Sachin here with another blog on Match Function in Excel. In this tutorial we will discuss the following things about Match Function of excel

1.) Syntax and insight of Match Function

2.) Uses of match function with practical example

3.) Things to be taken care while using it


Syntax and insight of Match Function

=MATCH(lookup_value, lookup_array, [match_type])

1- Lookup value – The value to look for in an array

2- Array – the table from which the excel will search for lookup value

3- match type – It can be exact or approx match

Match type Explanation
0
stand for exact match
1
stand for approx match which will finds the largest value that is less than or equal to lookup_value. how ??- first find the greater value than the lookup value and then shift one cell upside
-1
Minus 1 also stand for approx value which will finds the smallest value that is greater than or equal to lookup_value. how?? – first find value smaller than that and then move one cell down


Uses of match function with practical example

When to use Match function – When you want to find the relative position of lookup value in the table array.

Example – 1 Match with exact Match

Explanation – here Tenna relative position in table array is 10th so the result is 10th

Example -2 Match function with approx match 1

Explanation – given in table listed below in image

Example -3 Match Function with minus 1 i:e (-1) match type

Explanation – given in table listed below in image


Things to be taken care while using it

1.) Always use Approximate 1 or -1 in case lookup value is number

2.) Sort data in ascending order if the approximate used in match type is 1 otherwise it will give False result

3.) Sort the data in descending order if the approximate used in match is -1
otherwise it will give False result

Final words

Although Match function alone would not be of much use but when combined with V lookup and Index it can be of so much use which will be discussed in upcoming blogs

Thank you for reading the blog

comment below in case of any query and fell free to give your opinion about blog

103 thoughts on “Match function in excel and its uses

  1. Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your website?
    My website is in the exact same area of interest as yours and my users would definitely benefit from a lot of
    the information you provide here. Please let me know
    if this ok with you. Thanks!

  2. After I originally left a comment I appear to have clicked the -Notify me when new comments
    are added- checkbox and now every time a comment is added I receive four
    emails with the same comment. Perhaps there is a way you can remove me from
    that service? Kudos!

  3. Greate pieces. Keep posting such kind of information on your site.
    Im really impressed by it.
    Hi there, You’ve done an incredible job. I’ll certainly digg it and in my
    view suggest to my friends. I am sure they’ll be benefited from this website.

  4. Hi,

    I’ve been visiting your website a few times and decided to give you some positive feedback because I find it very useful. Well done.

    I was wondering if you as someone with experience of creating a useful website could help me out with my new site by giving some feedback about what I could improve?

    You can find my site by searching for “casino gorilla” in Google (it’s the gorilla themed online casino comparison).

    I would appreciate if you could check it out quickly and tell me what you think.

    casinogorilla.com

    Thank you for help and I wish you a great week!

  5. Can I simply just say what a relief to uncover somebody who genuinely knows what they’re discussing on the net.
    You actually know how to bring an issue to light and make it important.
    More people need to look at this and understand this side
    of the story. I was surprised you’re not more popular given that you most certainly
    have the gift.

  6. You actually make it seem so easy with your presentation but I in finding this matter to be really something which I believe I might never understand.
    It kind of feels too complex and very vast for me. I am having a look
    forward to your subsequent submit, I’ll try to get the grasp of it!

  7. What’s up everyone, it’s my first visit at this web
    page, and piece of writing is really fruitful for me, keep up posting these types of articles.

  8. Wonderful blog! I found it while browsing on Yahoo News.
    Do you have any tips on how to get listed in Yahoo News? I’ve been trying for
    a while but I never seem to get there! Thanks

  9. Wow that was strange. I just wrote an incredibly long comment
    but after I clicked submit my comment didn’t show up.

    Grrrr… well I’m not writing all that over again. Anyhow, just wanted
    to say fantastic blog!

  10. I think this is among the most vital info for me. And i am
    glad reading your article. But want to remark on some general things, The site style is perfect,
    the articles is really nice : D. Good job, cheers

  11. My brother suggested I might like this web site. He was totally right.
    This post truly made my day. You cann’t imagine simply how
    much time I had spent for this info! Thanks!

  12. Oh my goodness! Incredible article dude! Thanks, However I am having
    issues with your RSS. I don’t know why I cannot join it. Is there
    anyone else getting identical RSS issues? Anybody who knows the answer can you kindly respond?
    Thanx!!

  13. hey there and thank you for your info – I’ve certainly picked up something new from right here.
    I did however expertise several technical issues using this web site, as I experienced to reload
    the site lots of times previous to I could get it to load correctly.

    I had been wondering if your web hosting is OK? Not that I’m complaining, but sluggish loading instances times will very frequently affect
    your placement in google and can damage your high-quality score if ads
    and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and can look out for a lot more of your respective intriguing
    content. Make sure you update this again very soon.

  14. Have you ever considered about adding a little bit more than just your articles?
    I mean, what you say is fundamental and all. But think about
    if you added some great images or video clips to give
    your posts more, “pop”! Your content is excellent but with images and
    videos, this site could definitely be one of the most beneficial in its niche.
    Wonderful blog!

  15. Hello! Do you use Twitter? I’d like to follow you if that would be ok.
    I’m definitely enjoying your blog and look forward to new posts.

  16. Your style is really unique in comparison to other people
    I have read stuff from. Many thanks for posting when you have the opportunity, Guess
    I will just bookmark this blog.

  17. When someone writes an piece of writing he/she retains the plan of a user in his/her
    mind that how a user can understand it. So that’s why this piece of writing is great.
    Thanks!

  18. Hi I am so thrilled I found your web site, I really found you by mistake, while I was searching on Askjeeve for something else, Nonetheless I am here now and would just like
    to say many thanks for a marvelous post and a all round interesting blog (I
    also love the theme/design), I don’t have time to look over it all at the
    minute but I have saved it and also added in your RSS feeds,
    so when I have time I will be back to read more, Please do
    keep up the awesome work.

  19. When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several
    emails with the same comment. Is there any way you can remove me from that service?
    Thanks!

  20. I like what you guys are usually up too. This kind of clever
    work and exposure! Keep up the terrific works guys I’ve included
    you guys to my own blogroll.

  21. Hello there! Quick question that’s completely off topic.
    Do you know how to make your site mobile friendly?
    My blog looks weird when browsing from my iphone.
    I’m trying to find a template or plugin that might be able to
    resolve this issue. If you have any recommendations, please share.

    Many thanks!

  22. Hey just wanted to give you a quick heads up and let you know a few of the images
    aren’t loading properly. I’m not sure why but I think its a
    linking issue. I’ve tried it in two different internet browsers and both show the same results.

  23. Very nice post. I just stumbled upon your weblog and wanted to say that I have truly enjoyed surfing around your blog posts.
    After all I’ll be subscribing to your feed and I hope you write again very soon!

  24. Excellent post. I used to be checking continuously this
    weblog and I’m inspired! Very useful information specifically the closing part :
    ) I care for such information a lot. I was seeking this particular info for a
    long time. Thank you and good luck.

  25. I’m extremely impressed with your writing skills as
    well as with the layout on your blog. Is this a paid theme
    or did you customize it yourself? Either way keep
    up the nice quality writing, it is rare to see a great blog like
    this one today.

  26. Greetings, There’s no doubt that your site could possibly be
    having browser compatibility issues. Whenever I take a look at your site in Safari, it
    looks fine however when opening in I.E., it has some overlapping issues.
    I just wanted to provide you with a quick heads up!
    Besides that, excellent website!

  27. Great goods from you, man. I’ve understand
    your stuff previous to and you’re just too excellent.
    I actually like what you’ve acquired here, really like what you’re stating and the
    way in which you say it. You make it entertaining and you
    still take care of to keep it wise. I can not wait to read much more from you.

    This is actually a terrific web site.

  28. I think that everything said was actually very reasonable.
    But, what about this? suppose you composed a catchier title?
    I mean, I don’t want to tell you how to run your blog,
    however what if you added a title that makes people want more?
    I mean Match function in excel and its uses – ExcelWala.Com is kinda vanilla.
    You could glance at Yahoo’s home page and watch how they write article
    headlines to get viewers to open the links. You might try adding a video or a related picture or two to
    get people interested about what you’ve got to say.
    In my opinion, it would bring your posts a
    little livelier.

  29. Thanks for your personal marvelous posting! I genuinely enjoyed reading it, you’re a great author.I will make
    certain to bookmark your blog and definitely will come back in the future.
    I want to encourage continue your great work, have a nice day!

  30. It is appropriate time to make a few plans for the long run and it is time to be happy.
    I have read this post and if I may just I desire
    to recommend you some fascinating things or advice.

    Perhaps you could write next articles referring to this article.
    I desire to read even more things about it!

  31. Hello There. I found your weblog the use of msn.
    This is a really smartly written article. I’ll be sure to bookmark it and return to learn extra
    of your helpful info. Thanks for the post. I will definitely return.

  32. Excellent goods from you, man. I have understand your stuff previous to and you’re
    just too wonderful. I really like what you have
    acquired here, certainly like what you are stating and the
    way in which you say it. You make it enjoyable and you still take
    care of to keep it smart. I can not wait to read much more from you.
    This is actually a terrific website.

  33. My spouse and I absolutely love your blog and find the majority of your
    post’s to be what precisely I’m looking for. Do you offer guest writers
    to write content for you personally? I wouldn’t mind creating a post
    or elaborating on a number of the subjects you write related to
    here. Again, awesome web log!

  34. I’ve been exploring for a little bit for any high-quality articles or blog posts in this sort of area .
    Exploring in Yahoo I ultimately stumbled upon this site. Reading this info
    So i’m glad to exhibit that I have an incredibly
    just right uncanny feeling I discovered exactly what I needed.
    I such a lot no doubt will make certain to don?t fail to remember this site and provides it
    a look regularly.

  35. When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a
    comment is added I get several e-mails with the same comment.
    Is there any way you can remove people from that service?
    Thanks!

  36. Hi there exceptional website! Does running a blog
    similar to this take a lot of work? I’ve very little expertise
    in programming but I had been hoping to start my own blog soon.
    Anyways, if you have any ideas or techniques for new blog owners please share.
    I know this is off topic however I simply had to ask.
    Thanks!

  37. Excellent post. I was checking constantly this blog and I’m impressed!
    Very useful information specifically the last part 🙂 I care for such info
    a lot. I was seeking this particular info for a long time.
    Thank you and best of luck.

  38. This is very interesting, You’re a very skilled blogger.
    I’ve joined your feed and look forward to seeking more of your wonderful post.
    Also, I have shared your site in my social networks!

  39. Greetings from California! I’m bored to tears at work so I decided to browse your blog
    on my iphone during lunch break. I enjoy the info you present here and can’t wait to take a look when I get home.
    I’m surprised at how fast your blog loaded on my cell phone ..
    I’m not even using WIFI, just 3G .. Anyhow, great site!

  40. You really make it seem so easy with your presentation but I find this topic to be really something that I think I would
    never understand. It seems too complicated and very broad for me.

    I’m looking forward for your next post, I’ll try to get the hang of it!

  41. It’s a pity you don’t have a donate button! I’d definitely donate to this brilliant blog!
    I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account.

    I look forward to new updates and will talk about
    this blog with my Facebook group. Chat soon!

  42. When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get
    three emails with the same comment. Is there any way
    you can remove people from that service? Many thanks!

  43. This is the perfect web site for anybody who hopes to understand this topic.

    You know so much its almost hard to argue with you (not that I
    really would want to…HaHa). You definitely put a brand new spin on a topic that has been written about for decades.
    Wonderful stuff, just great!

  44. Thank you for another great post. The place else
    could anyone get that type of information in such a perfect manner of
    writing? I have a presentation next week, and I’m on the
    search for such info.

  45. Hello there, I do believe your blog may be having browser compatibility problems.
    Whenever I look at your website in Safari, it looks fine however,
    when opening in Internet Explorer, it’s got some overlapping issues.
    I simply wanted to provide you with a quick heads up!

    Apart from that, excellent blog!

Leave a Reply

Your email address will not be published. Required fields are marked *