VLOOKUP

VLOOKUP adalah fungsi yang digunakan untuk mencari nilai referensi di kolom paling kiri dari suatu tabel, dan kemudian mengambil nilai di baris yang sama dari kolom tertentu tabel tersebut .

Cara penulisan:

VLOOKUP(nilai referensi, tabel, kolom tertentu,nilai logika)

nilai referensi = nilai yang dicari

tabel = range yang terdiri dari kolom dan baris

kolom  tertentu = nomor kolom dihitung dari kiri

nilai logika = di isi dengan TRUE atau FALSE

Contoh:

Coba ketikan data dibawah ini kedalam tabel, hanya data yang berada di range warna abu-abu

VLOOKUP

tabel = range berwarna abu-abu yaitu B2:E5

kolom tertentu = bisa kolom 1, kolom 2, dst.

nilai referensi = nilai apapun yang cocok dengan nilai di kolom 1

nilai logika = sementara gunakan saja FALSE

Sekarang masukan fungsi VLOOKUP berikut ini

di sel C8

=VLOOKUP(123,B2:E5,2,FALSE)

di sel C9

=VLOOKUP(456,B2:E5,4,FALSE)

di sel C10

=VLOOKUP(789,B2:E5,3,FALSE)

Hasilnya harus seperti ini

VLOOKUP-Hasil

Mari kita baca fungsi VLOOKUP di sel C8 dengan bahasa manusia.

Bahasa Excel  =VLOOKUP(123,B2:E5,2,FALSE)

dibaca: cari nilai referensi di kolom paling kiri dari suatu tabel, dan kemudian mengambil nilai di baris yang sama dari kolom tertentu tabel tersebut .

nilai referensi = 123

tabel = range B2:E5

kolom paling kiri = kolom 1

kolom tertentu = kolom 2

dibaca ulang: cari angka 123 di kolom 1 dari range B2:E5, dan kemudian ambil nilai di baris yang sama dari kolom 2

Ya, hasilnya Buah Mangga

Gampang kan?

Ada banyak variasi penulisan VLOOKUP lainnya yang berguna dalam aplikasi yang lebih rumit. Untuk saat ini, pahami dulu cara penulisan dan cara membaca fungsi VLOOKUP yang benar. Ikuti posting berikutnya yang memberi contoh nyata penggunaan VLOOKUP dalam pekerjaan sehari-hari.

32 thoughts on “VLOOKUP

  1. I’m writing to let you be aware of what a amazing encounter my friend’s daughter had reading through the blog. She realized too many things, including what it is like to have a great giving heart to have the others without difficulty thoroughly grasp a variety of complex subject areas. You really exceeded her expected results. Many thanks for delivering the warm and helpful, healthy, explanatory and in addition easy tips about that topic to Ethel.

  2. Thanks so much for giving everyone an extremely spectacular opportunity to discover important secrets from this web site. It is often so kind and as well , packed with a great time for me and my office peers to visit your web site at least three times per week to read through the newest tips you will have. And lastly, I’m certainly happy with the perfect guidelines served by you. Certain 4 ideas in this posting are honestly the most beneficial I’ve had.

  3. I happen to be writing to let you be aware of what a superb discovery our girl had using the blog. She noticed lots of things, not to mention how it is like to have an amazing teaching mood to make other people effortlessly fully understand a variety of complex matters. You really exceeded our own desires. Many thanks for providing these powerful, trustworthy, revealing and even cool tips on that topic to Emily.

  4. I am just writing to make you be aware of what a helpful experience my cousin’s daughter obtained reading your web page. She even learned numerous pieces, which included what it’s like to have a great coaching heart to get most people smoothly know specified grueling matters. You really exceeded our expectations. Many thanks for distributing these effective, dependable, edifying and even unique thoughts on that topic to Jane.

  5. I not to mention my pals appeared to be examining the excellent guidelines from your web page and suddenly came up with a horrible suspicion I never thanked you for those techniques. My boys are already absolutely very interested to read all of them and have in effect absolutely been loving those things. Appreciation for simply being really thoughtful and for picking out certain nice guides most people are really desirous to be aware of. My sincere apologies for not expressing gratitude to sooner.

  6. I intended to write you a tiny remark just to thank you very much over again about the magnificent tips you’ve provided on this website. It is certainly seriously open-handed of you to deliver without restraint exactly what many people could have offered for sale for an e book to help make some dough for themselves, even more so considering the fact that you might well have done it if you considered necessary. These ideas likewise served to be the easy way to understand that other people online have the identical dream really like my personal own to know a little more on the topic of this condition. I’m certain there are numerous more pleasant opportunities in the future for folks who read carefully your blog.

  7. Thanks so much for giving everyone an extraordinarily special opportunity to read critical reviews from this website. It is always very ideal and stuffed with a lot of fun for me personally and my office fellow workers to visit your web site at minimum thrice weekly to study the newest secrets you will have. And definitely, I am also at all times impressed with your eye-popping inspiring ideas served by you. Certain 1 ideas on this page are completely the most suitable we have had.

  8. I am glad for writing to let you be aware of what a awesome encounter our girl obtained going through your site. She figured out such a lot of issues, not to mention how it is like to possess an excellent helping character to have a number of people clearly comprehend certain specialized subject areas. You really surpassed our desires. I appreciate you for offering the essential, healthy, revealing as well as fun thoughts on your topic to Sandra.

  9. I am writing to make you understand what a terrific encounter my wife’s girl had going through your webblog. She discovered such a lot of pieces, which included how it is like to have an excellent coaching heart to get many more with no trouble understand various very confusing subject matter. You actually exceeded her desires. Thank you for rendering the practical, trustworthy, edifying and as well as cool tips about the topic to Julie.

  10. Thanks a lot for giving everyone an extremely splendid possiblity to read articles and blog posts from this site. It’s always so lovely and stuffed with fun for me and my office colleagues to search your blog particularly three times every week to see the newest issues you have got. And indeed, I’m at all times pleased for the exceptional techniques served by you. Selected 1 points on this page are undoubtedly the most effective I have had.

  11. I’m just commenting to let you know what a brilliant discovery my wife’s princess enjoyed using the blog. She picked up plenty of pieces, most notably what it is like to have a wonderful helping mood to have the mediocre ones completely learn specified impossible topics. You really surpassed people’s expected results. Thanks for rendering these necessary, trusted, revealing and as well as fun guidance on that topic to Janet.

  12. Thanks a lot for providing individuals with a very breathtaking opportunity to discover important secrets from this blog. It is usually so kind and as well , packed with amusement for me and my office peers to visit your web site on the least 3 times a week to learn the newest tips you have. Not to mention, I am also usually impressed for the good inspiring ideas you give. Certain two areas in this post are really the most impressive we’ve ever had.

  13. Thank you for your entire hard work on this web page. Debby enjoys working on investigation and it’s really easy to see why. Many of us notice all regarding the lively ways you offer worthwhile suggestions via the web blog and even encourage contribution from others on that subject matter so our favorite princess has always been studying so much. Take advantage of the rest of the new year. You’re performing a remarkable job.

  14. I truly wanted to compose a remark to be able to say thanks to you for these splendid secrets you are writing at this site. My long internet lookup has now been recognized with reasonable content to go over with my friends. I would state that that we site visitors actually are undeniably lucky to dwell in a useful network with many awesome individuals with very helpful strategies. I feel really grateful to have come across your entire webpages and look forward to many more excellent minutes reading here. Thanks a lot once again for all the details.

  15. I want to get across my respect for your kindness for folks who must have help on the question. Your very own commitment to getting the message across turned out to be remarkably functional and have always empowered employees like me to realize their objectives. Your insightful help entails so much a person like me and especially to my fellow workers. Many thanks; from all of us.

  16. Thanks a lot for giving everyone such a memorable possiblity to read critical reviews from this site. It’s always very enjoyable and as well , stuffed with amusement for me personally and my office fellow workers to search the blog at least three times every week to read the new guides you have. And lastly, I am also at all times contented concerning the effective ideas served by you. Certain 3 ideas in this post are honestly the most suitable we’ve had.

  17. I wanted to write down a quick word to be able to say thanks to you for all the pleasant ways you are writing on this website. My considerable internet lookup has at the end of the day been paid with excellent know-how to talk about with my contacts. I ‘d claim that most of us site visitors actually are unquestionably fortunate to live in a really good network with very many wonderful people with helpful pointers. I feel somewhat fortunate to have used the weblog and look forward to some more entertaining minutes reading here. Thanks again for everything.

  18. I precisely wished to thank you very much all over again. I’m not certain the things that I could possibly have sorted out in the absence of the type of strategies documented by you directly on this question. It actually was a frightening circumstance in my view, nevertheless understanding your skilled approach you treated it made me to weep with joy. I will be happier for your help and as well , hope you really know what a great job you are accomplishing teaching others thru a site. I am certain you haven’t met all of us.

  19. I needed to write you a little observation to thank you the moment again over the pleasant pointers you’ve contributed in this article. It is simply shockingly open-handed with you to deliver unreservedly what a few individuals would have advertised as an electronic book to make some profit for their own end, principally since you could possibly have done it in case you desired. Those concepts likewise served like a great way to know that some people have the same interest really like my personal own to figure out more and more with reference to this issue. I am sure there are millions of more pleasurable sessions ahead for individuals that view your site.

  20. Thank you a lot for providing individuals with an extraordinarily wonderful chance to read articles and blog posts from this site. It’s usually very pleasing and also stuffed with amusement for me and my office peers to visit your web site particularly 3 times every week to read the fresh tips you have. And indeed, I am also always fascinated with all the beautiful creative concepts served by you. Selected 4 facts in this post are truly the most impressive I have had.

  21. Thanks for all of your work on this web site. Betty really likes doing investigations and it’s really simple to grasp why. Almost all hear all regarding the compelling medium you create sensible tactics on this web blog and even improve participation from others on this concern plus our own child has always been learning a whole lot. Enjoy the remaining portion of the new year. You have been performing a tremendous job.

  22. I and also my friends happened to be digesting the great information and facts located on your website while all of a sudden I had a terrible feeling I never expressed respect to the web blog owner for those strategies. My guys happened to be for this reason glad to study all of them and have in effect seriously been making the most of them. Appreciate your simply being very kind and also for settling on these kinds of remarkable issues millions of individuals are really desperate to be aware of. My personal sincere regret for not expressing appreciation to sooner.

  23. My spouse and i ended up being joyful when Emmanuel managed to finish up his analysis from your ideas he had while using the web site. It is now and again perplexing to simply continually be giving for free concepts which often people today could have been making money from. And we recognize we have got you to give thanks to for this. The type of explanations you have made, the simple site navigation, the relationships you make it possible to foster – it’s got everything astounding, and it’s really assisting our son and us reason why that content is fun, which is certainly exceptionally serious. Many thanks for all the pieces!

  24. I precisely wished to thank you so much yet again. I do not know the things that I would’ve taken care of without those ways provided by you on such a problem. It was before a horrifying condition for me personally, however , considering this professional manner you handled the issue made me to jump for happiness. I will be thankful for your support and thus hope you realize what a great job you are always providing educating people via your web site. Most likely you’ve never met all of us.

  25. I wish to get across my passion for your kindness giving support to people that must have help with this idea. Your real dedication to passing the message across had been pretty important and has without exception helped people much like me to reach their aims. Your entire interesting advice signifies a great deal a person like me and extremely more to my office workers. Best wishes; from each one of us.

  26. I must show some appreciation to you for rescuing me from this type of issue. As a result of scouting through the world-wide-web and seeing basics which are not powerful, I assumed my life was over. Being alive minus the answers to the problems you’ve resolved by means of your post is a critical case, as well as the ones which could have in a wrong way damaged my career if I had not noticed your web page. Your own capability and kindness in handling every item was crucial. I’m not sure what I would have done if I hadn’t come across such a solution like this. It’s possible to at this time relish my future. Thanks very much for your impressive and results-oriented help. I will not be reluctant to endorse your blog to anybody who needs direction about this matter.

  27. Thank you so much for providing individuals with such a pleasant opportunity to check tips from this web site. It is always very beneficial and jam-packed with a good time for me and my office mates to visit your web site minimum three times every week to read through the latest guidance you will have. And of course, we are at all times pleased with your fabulous creative ideas served by you. Some 2 tips in this article are undeniably the most suitable I have ever had.

  28. I and my buddies happened to be analyzing the excellent helpful tips from your web blog and the sudden came up with a horrible suspicion I never thanked the website owner for those techniques. These young men were absolutely thrilled to study them and have now unquestionably been taking pleasure in these things. Many thanks for getting well thoughtful as well as for having this sort of essential themes most people are really desperate to understand about. Our sincere apologies for not expressing gratitude to you earlier.

  29. I wanted to put you the very small observation so as to thank you so much again with your magnificent secrets you have provided on this website. This is certainly shockingly generous of people like you to give without restraint precisely what some people would’ve offered for an ebook to help make some cash for their own end, primarily now that you could possibly have tried it in the event you desired. The pointers in addition acted to be the great way to realize that some people have a similar dream the same as mine to find out a whole lot more with reference to this condition. I am sure there are several more pleasurable times ahead for people who take a look at your blog post.

  30. Thank you so much for providing individuals with remarkably spectacular opportunity to discover important secrets from this web site. It is usually so ideal and packed with amusement for me and my office friends to visit the blog at a minimum three times in a week to read through the latest issues you will have. Not to mention, I am just always astounded with all the exceptional principles served by you. Selected 4 points in this posting are unquestionably the best I have ever had.

  31. I enjoy you because of your entire effort on this blog. Betty loves managing investigation and it’s simple to grasp why. Most of us notice all of the lively manner you present reliable guidance through your web site and welcome response from some other people on the article plus our favorite simple princess is becoming educated a lot of things. Take pleasure in the remaining portion of the new year. You’re the one doing a tremendous job.

Leave a Reply

Your email address will not be published.