엑셀 MATCH함수로 데이터의 위치 찾기

  함수 형식 : =MATCH(lookup_value, lookup_array, match_type)

  lookup_value : 찾으려는 값

  lookup_array : 찾으려는 값이 있는 셀 범위

  match_type : 찾는 방법 (생략 또는 1이면 오름차순에서 비슷한 값, -1이면 내림차순에서 비슷한 값, 0이면 일치된 값

아래그림에서와 같이  lookup_array 영역을 가로로 A1에서E1 까지(A1:E1)이라고 지정하고 “이름”이라는 글자를 찾으면
가로 “2”번째 있다고 결과를 표시한다.

 

lookup_array 영역을 세로로 B1에서B22 까지(B1:B22)이라고 지정하고 “이름”이라는 글자를 찾으면
세로 “1”번째 있다고 결과를 표시한다.

image

 

 

“엑셀 MATCH함수로 데이터의 위치 찾기”의 223개의 댓글

  1. This is really interesting, You’re a very skilled blogger.
    I have joined your feed and sit up for in the hunt for more of your
    magnificent post. Additionally, I’ve shared your website in my social networks

  2. I simply want to mention I am newbie to blogs and actually savored you’re web page. More than likely I’m likely to bookmark your site . You absolutely come with exceptional posts. With thanks for revealing your website page.

  3. Great article. I find out something extra tough on various blog sites everyday. It will certainly constantly be boosting to review material from various other writers and also practice a little something from their shop. I?d choose to make use of some with the material on my blog site whether you don?t mind. Natually I?ll offer you a web link on your internet blog. Thanks for sharing.

  4. I’m honored to obtain a call from a friend as he identified the important tips shared on your site. Browsing your blog post is a real excellent experience. Many thanks for taking into consideration readers at all like me, and I wish you the best of achievements as being a professional domain.

  5. Hi! I know this is sort of off-topic however I needed to ask. Does running a well-established website like yours require a lot of work? I am brand new to blogging however I do write in my journal daily. I’d like to start a blog so I will be able to share my own experience and thoughts online. Please let me know if you have any kind of suggestions or tips for new aspiring blog owners. Appreciate it!

  6. When I originally commented I clicked the -Alert me when new comments are added- checkbox and also now each time a remark is added I obtain 4 e-mails with the very same comment. Exists any way you can remove me from that solution? Thanks!

  7. I?m amazed, I must say. Truly rarely do I encounter a blog site that?s both informative as well as entertaining, and let me inform you, you have actually hit the nail on the head. Your concept is outstanding; the problem is something that insufficient individuals are speaking smartly about. I am very delighted that I stumbled across this in my look for something connecting to this.

  8. When I originally commented I clicked the -Notify me when new remarks are added- checkbox and also now each time a remark is added I get 4 emails with the very same comment. Exists any way you can remove me from that solution? Many thanks!

  9. Hello there! This post couldn’t be written much better! Going through this article reminds me of my previous roommate! He always kept preaching about this. I most certainly will forward this post to him. Pretty sure he will have a very good read. I appreciate you for sharing!

  10. I have to thank you for the efforts you’ve put in penning this blog. I’m hoping to see the same high-grade content by you later on as well. In fact, your creative writing abilities has inspired me to get my own, personal blog now 😉

  11. Aw, this was a very nice post. Spending some time and actual effort to create a top notch article… but what can I say… I put things off a lot and never seem to get anything done.

  12. After exploring a handful of the blog articles on your website, I seriously like your technique of blogging. I added it to my bookmark webpage list and will be checking back soon. Take a look at my website as well and tell me how you feel.

  13. Nice post. I learn something new and challenging on blogs I stumbleupon on a daily basis. It’s always useful to read content from other authors and use something from their sites.

  14. An interesting discussion is definitely worth comment. I think that you should write more on this subject, it may not be a taboo matter but typically folks don’t discuss such issues. To the next! Many thanks!!

  15. Hi, I do think your blog might be having internet browser compatibility problems. When I look at your website in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I simply wanted to provide you with a quick heads up! Aside from that, wonderful site!

  16. Can I just state what a relief to locate somebody that in fact understands what theyre talking about on the internet. You absolutely understand how to bring a concern to light and make it essential. More individuals require to read this and also comprehend this side of the story. I angle believe youre not extra prominent due to the fact that you most definitely have the gift.

  17. Having read this I thought it was extremely enlightening. I appreciate you taking the time and effort to put this information together. I once again find myself spending way too much time both reading and leaving comments. But so what, it was still worthwhile!

  18. Hello there! This post could not be written much better! Looking at this post reminds me of my previous roommate! He continually kept preaching about this. I most certainly will forward this post to him. Pretty sure he’s going to have a good read. Many thanks for sharing!

  19. I’m amazed, I must say. Rarely do I come across a blog that’s both educative and engaging, and let me tell you, you have hit the nail on the head. The problem is something which too few folks are speaking intelligently about. I’m very happy I came across this in my hunt for something regarding this.

  20. I’m impressed, I have to admit. Rarely do I encounter a blog that’s both educative and amusing, and without a doubt, you’ve hit the nail on the head. The problem is something which not enough people are speaking intelligently about. I am very happy I came across this during my search for something concerning this.

  21. Having read this I thought it was really informative. I appreciate you finding the time and effort to put this short article together. I once again find myself personally spending way too much time both reading and leaving comments. But so what, it was still worth it!

  22. The very next time I read a blog, Hopefully it doesn’t fail me as much as this particular one. After all, Yes, it was my choice to read, however I actually believed you’d have something interesting to say. All I hear is a bunch of moaning about something that you could fix if you weren’t too busy seeking attention.

  23. Hi there, I do believe your blog could possibly be having internet browser compatibility issues. Whenever I look at your web site in Safari, it looks fine however, when opening in I.E., it has some overlapping issues. I just wanted to give you a quick heads up! Besides that, great site!

  24. Hi, I do think this is a great site. I stumbledupon it 😉 I will revisit yet again since I book marked it. Money and freedom is the greatest way to change, may you be rich and continue to help other people.

  25. I seriously love your site.. Excellent colors & theme. Did you create this amazing site yourself? Please reply back as I’m planning to create my own website and would like to know where you got this from or just what the theme is called. Thank you!

  26. A fascinating discussion is worth comment. I think that you need to write more about this subject, it might not be a taboo matter but usually folks don’t discuss these issues. To the next! Cheers!!

  27. The next time I read a blog, Hopefully it won’t fail me just as much as this particular one. I mean, Yes, it was my choice to read, nonetheless I actually thought you’d have something useful to say. All I hear is a bunch of moaning about something that you can fix if you weren’t too busy looking for attention.

  28. Hi there! This article couldn’t be written any better! Going through this article reminds me of my previous roommate! He constantly kept talking about this. I am going to forward this article to him. Pretty sure he’s going to have a great read. Thanks for sharing!

  29. The very next time I read a blog, Hopefully it does not disappoint me just as much as this particular one. After all, Yes, it was my choice to read through, however I actually believed you would probably have something helpful to talk about. All I hear is a bunch of moaning about something that you could fix if you were not too busy searching for attention.

  30. This is the right webpage for everyone who would like to understand this topic. You know a whole lot its almost tough to argue with you (not that I really will need to…HaHa). You definitely put a new spin on a topic that’s been discussed for ages. Wonderful stuff, just great!

  31. Hi there, I do think your website could possibly be having web browser compatibility problems. Whenever I take a look at your web site in Safari, it looks fine however, when opening in I.E., it has some overlapping issues. I just wanted to give you a quick heads up! Aside from that, wonderful site!

  32. I have to thank you for the efforts you’ve put in writing this blog. I really hope to see the same high-grade content from you later on as well. In fact, your creative writing abilities has inspired me to get my very own site now 😉

  33. Aw, this was an incredibly good post. Finding the time and actual effort to produce a top notch article… but what can I say… I hesitate a whole lot and never seem to get nearly anything done.

  34. I must thank you for the efforts you’ve put in penning this website. I am hoping to view the same high-grade content from you later on as well. In truth, your creative writing abilities has inspired me to get my very own blog now 😉

  35. I really love your blog.. Excellent colors & theme. Did you develop this website yourself? Please reply back as I’m hoping to create my own personal blog and would like to know where you got this from or what the theme is named. Thank you!

  36. I seriously love your blog.. Excellent colors & theme. Did you create this site yourself? Please reply back as I’m planning to create my own personal website and would love to know where you got this from or exactly what the theme is named. Cheers!

  37. After looking over a number of the blog posts on your blog, I really like your technique of blogging. I saved as a favorite it to my bookmark webpage list and will be checking back soon. Take a look at my website as well and tell me your opinion.

  38. Spot on with this write-up, I actually believe that this website needs much more attention. I’ll probably be returning to see more, thanks for the advice!

  39. I blog often and I genuinely appreciate your content. The article has really peaked my interest. I will bookmark your website and keep checking for new details about once per week. I opted in for your RSS feed too.

  40. Hello there, I believe your blog might be having web browser compatibility problems. When I take a look at your website in Safari, it looks fine however when opening in IE, it’s got some overlapping issues. I simply wanted to give you a quick heads up! Aside from that, wonderful blog!

  41. Everything is very open with a really clear clarification of the challenges. It was really informative. Your site is very useful. Thanks for sharing!

  42. You’re so interesting! I do not think I’ve truly read something like that before. So good to find somebody with some original thoughts on this issue. Seriously.. thanks for starting this up. This web site is something that’s needed on the web, someone with a little originality!

  43. An outstanding share! I have just forwarded this onto a friend who has been doing a little homework on this. And he in fact bought me breakfast because I discovered it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending some time to discuss this topic here on your site.

  44. May I simply just say what a relief to discover someone who truly understands what they are discussing on the web. You certainly understand how to bring an issue to light and make it important. More and more people should check this out and understand this side of the story. I was surprised that you aren’t more popular given that you surely have the gift.

  45. Aw, this was a truly wonderful article. In idea I wish to place in writing similar to this additionally? requiring time and actual effort to make a very good short article? however what can I say? I hesitate alot as well as never seem to get something done.

  46. I blog often and I seriously appreciate your information. Your article has truly peaked my interest. I am going to bookmark your site and keep checking for new information about once per week. I opted in for your Feed as well.

  47. I have to thank you for the efforts you have put in writing this site. I’m hoping to check out the same high-grade blog posts by you in the future as well. In truth, your creative writing abilities has inspired me to get my own, personal website now 😉

  48. Having read this I thought it was extremely informative. I appreciate you taking the time and effort to put this content together. I once again find myself spending way too much time both reading and leaving comments. But so what, it was still worth it!

  49. Nice post. I learn something new and challenging on blogs I stumbleupon everyday. It’s always interesting to read content from other authors and use a little something from their websites.

  50. Hi, I do think this is an excellent website. I stumbledupon it 😉 I am going to come back yet again since I book marked it. Money and freedom is the best way to change, may you be rich and continue to help others.

  51. I’m impressed, I have to admit. Seldom do I come across a blog that’s both educative and amusing, and without a doubt, you have hit the nail on the head. The issue is an issue that not enough men and women are speaking intelligently about. Now i’m very happy that I came across this in my hunt for something concerning this.

  52. This is the perfect web site for everyone who wants to find out about this topic. You know so much its almost tough to argue with you (not that I actually will need to…HaHa). You certainly put a fresh spin on a subject that has been written about for decades. Wonderful stuff, just excellent!

  53. Nice post. I find out something much more tough on different blogs daily. It will constantly be stimulating to read material from other writers as well as exercise a little something from their shop. I?d like to utilize some with the material on my blog site whether you don?t mind. Natually I?ll offer you a web link on your web blog site. Thanks for sharing.

  54. Having read this I believed it was extremely enlightening. I appreciate you spending some time and effort to put this content together. I once again find myself spending a significant amount of time both reading and posting comments. But so what, it was still worth it!

  55. This is the right webpage for anyone who would like to understand this topic. You know a whole lot its almost tough to argue with you (not that I personally will need to…HaHa). You definitely put a new spin on a subject which has been written about for ages. Wonderful stuff, just great!

  56. Hi, I do think this is a great blog. I stumbledupon it 😉 I am going to come back once again since I book marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.

  57. I blog frequently and I truly thank you for your content. The article has truly peaked my interest. I am going to take a note of your website and keep checking for new details about once a week. I subscribed to your RSS feed as well.

  58. The very next time I read a blog, I hope that it won’t disappoint me as much as this particular one. After all, Yes, it was my choice to read through, however I actually thought you would have something helpful to talk about. All I hear is a bunch of moaning about something you could possibly fix if you weren’t too busy seeking attention.

  59. You are so interesting! I don’t think I’ve read anything like that before. So great to discover someone with a few genuine thoughts on this subject. Seriously.. thank you for starting this up. This web site is one thing that is required on the web, someone with some originality!

  60. Hello! I just wish to give you a huge thumbs up for the excellent info you have right here on this post. I am coming back to your website for more soon.

  61. Nice post. I learn something new and challenging on sites I stumbleupon on a daily basis. It’s always exciting to read through articles from other writers and practice something from other sites.

  62. Oh my goodness! Incredible article dude! Thank you so much, However I am experiencing problems with your RSS. I don’t understand why I am unable to subscribe to it. Is there anybody having identical RSS problems? Anyone who knows the answer can you kindly respond? Thanks!!

  63. Wonderful message. I discover something more challenging on various blog sites day-to-day. It will certainly constantly be stimulating to check out material from other writers as well as exercise a something from their store. I?d favor to utilize some with the content on my blog site whether you don?t mind. Natually I?ll provide you a web link on your internet blog. Thanks for sharing.

  64. This is the perfect site for anybody who wants to understand this topic. You know a whole lot its almost hard to argue with you (not that I personally would want to…HaHa). You definitely put a fresh spin on a topic that has been discussed for many years. Great stuff, just great!

  65. Greetings, I do believe your blog could be having browser compatibility issues. When I take a look at your blog in Safari, it looks fine however, when opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to give you a quick heads up! Other than that, great blog!

  66. Aw, this was an exceptionally good post. Spending some time and actual effort to produce a really good article… but what can I say… I put things off a lot and never seem to get anything done.

  67. Hello there, I believe your site may be having web browser compatibility issues. Whenever I look at your web site in Safari, it looks fine however, when opening in IE, it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Apart from that, great site!

  68. I was pretty pleased to uncover this web site. I need to to thank you for ones time for this wonderful read!! I definitely really liked every little bit of it and i also have you saved as a favorite to check out new information on your site.

  69. Your style is really unique compared to other people I have read stuff from. Thank you for posting when you’ve got the opportunity, Guess I will just book mark this web site.

  70. Can I simply say what a comfort to uncover somebody who genuinely understands what they’re talking about on the internet. You actually realize how to bring a problem to light and make it important. More and more people must read this and understand this side of the story. I was surprised that you aren’t more popular because you definitely have the gift.

  71. I’m amazed, I must say. Rarely do I come across a blog that’s both equally educative and engaging, and without a doubt, you have hit the nail on the head. The issue is an issue that too few folks are speaking intelligently about. I’m very happy I came across this in my search for something relating to this.

  72. An intriguing conversation is worth comment. I believe that you should write a lot more on this topic, it may not be a forbidden topic however normally individuals are inadequate to speak on such subjects. To the next. Thanks

  73. Hello, I do think your web site could possibly be having web browser compatibility problems. Whenever I take a look at your website in Safari, it looks fine however when opening in IE, it has some overlapping issues. I just wanted to provide you with a quick heads up! Other than that, wonderful site!

  74. Right here is the perfect website for anyone who wishes to find out about this topic. You realize a whole lot its almost tough to argue with you (not that I really would want to…HaHa). You certainly put a new spin on a subject that’s been discussed for decades. Great stuff, just great!

  75. An outstanding share! I’ve just forwarded this onto a friend who has been doing a little homework on this. And he actually bought me dinner simply because I discovered it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending the time to discuss this topic here on your web page.

  76. I truly love your blog.. Very nice colors & theme. Did you create this site yourself? Please reply back as I’m planning to create my very own website and want to know where you got this from or just what the theme is named. Appreciate it!

  77. Having read this I believed it was very enlightening. I appreciate you finding the time and effort to put this article together. I once again find myself spending way too much time both reading and leaving comments. But so what, it was still worthwhile!

  78. I blog quite often and I genuinely appreciate your content. The article has really peaked my interest. I will bookmark your site and keep checking for new details about once per week. I opted in for your RSS feed as well.

  79. You’re so awesome! I don’t suppose I have read through anything like that before. So great to find somebody with some unique thoughts on this issue. Really.. thank you for starting this up. This site is one thing that is required on the web, someone with some originality!

  80. I’m impressed, I must say. Rarely do I encounter a blog that’s equally educative and engaging, and let me tell you, you have hit the nail on the head. The problem is something not enough men and women are speaking intelligently about. I’m very happy I found this during my hunt for something concerning this.

  81. This is the right webpage for anybody who wants to find out about this topic. You know a whole lot its almost hard to argue with you (not that I really will need to…HaHa). You definitely put a fresh spin on a topic that has been written about for a long time. Wonderful stuff, just great!

  82. I’d like to thank you for the efforts you’ve put in writing this site. I am hoping to check out the same high-grade blog posts by you later on as well. In truth, your creative writing abilities has motivated me to get my own, personal site now 😉

  83. Hi there! This post couldn’t be written any better! Going through this article reminds me of my previous roommate! He constantly kept talking about this. I will send this information to him. Pretty sure he will have a great read. Many thanks for sharing!

  84. A fascinating discussion is worth comment. I believe that you ought to write more on this subject, it may not be a taboo subject but generally people don’t talk about such subjects. To the next! Kind regards!!

  85. You’re so interesting! I do not suppose I’ve read something like that before. So nice to discover another person with some unique thoughts on this issue. Seriously.. thank you for starting this up. This site is something that’s needed on the internet, someone with a little originality!

  86. You’re so awesome! I do not think I have read anything like this before. So great to find someone with a few unique thoughts on this topic. Seriously.. thanks for starting this up. This website is one thing that is needed on the internet, someone with some originality!

  87. Aw, this was an extremely good post. Spending some time and actual effort to generate a top notch article… but what can I say… I put things off a whole lot and don’t seem to get anything done.

  88. I blog frequently and I truly thank you for your information. The article has really peaked my interest. I’m going to take a note of your site and keep checking for new information about once a week. I subscribed to your Feed too.

  89. I’d like to thank you for the efforts you’ve put in writing this website. I’m hoping to see the same high-grade content by you in the future as well. In truth, your creative writing abilities has motivated me to get my very own website now 😉

  90. The very next time I read a blog, Hopefully it does not disappoint me as much as this particular one. After all, I know it was my choice to read through, however I really believed you’d have something interesting to say. All I hear is a bunch of whining about something you could fix if you weren’t too busy looking for attention.

  91. Howdy! This blog post could not be written any better! Looking through this article reminds me of my previous roommate! He always kept preaching about this. I am going to send this article to him. Fairly certain he’ll have a good read. Thanks for sharing!

  92. Hey very cool website!! Man .. Excellent .. Wonderful
    .. I will bookmark your web site and take the feeds additionally?

    I am glad to search out a lot of useful info here within the
    post, we want develop more strategies in this regard, thanks for
    sharing. . . . . .

  93. Great blog post. I find out something a lot more tough on various blog sites day-to-day. It will always be stimulating to review web content from various other writers and also exercise a something from their store. I?d choose to make use of some with the web content on my blog whether you don?t mind. Natually I?ll provide you a link on your internet blog. Thanks for sharing.

댓글 남기기