VLookup Function – Excel

Excel Vlookup Function

Vlookup is most widely used formula in Excel. Vlookup stands for “Vertical Lookup”. It searches the first column of a table array and then selects value in right hand side columns of table array in the same row.

Syntax:

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value: Lookup value is the value that has to be searched from the leftmost column or the  first column from the  table array. If lookup_value is found in the first column of the table array, it will look for the data in right hand side columns in same rows. Lookup_value works as a primary key which can be data value or reference. These can be numeric or text values.

Table_array: Table array can be data columns containing two or more columns. First columns in the table array should be the value containing lookup_value. Like lookup_value, these values can be numeric or text values.

Col_index_num: Col_index_num is numeric value or the column number to be return as output  It is defined in numbers like 1,2 3 and so on which are identified as column number to right hand side.

Range_lookup: Range lookup is a simple logical value: true or false to specifies whether you want find an exact match or an approximate match. That means if selected “FALSE”, formula will return value on exact match and will return error: #N/A in case of no value to return. In case of approximate match (TRUE), an exact or approximate match is returned and in case exact match is unavailable, next largest value that is less than lookup_value is returned. ’1′ and ’0′ can be also used in place of TRUE and FALSE respectively. Default value for range lookup is TRUE, if left blank.

Examples:

Here we have a table array of data in which we will use vlookup function.

A B
1 Department Id Department Name
2 7 Admin
3 3 Finance
4 9 Human Resource
5 5 Technology

Lets check with few syntax of vlookup on above data.

Formula 1:

=VLOOKUP(5,A2:B5,2,FALSE)

Result: The formula will returns Technology because it finds exact match.

Formula 2:

=VLOOKUP(4,A2:B5,2,FALSE)

Result: The formula will returns error #N/A because there is no exact value available in column A matching to 4.

Formula 3:

=VLOOKUP(4,A2:B5,2,TRUE)

Result: The formula will return Finance because it finds no exact match but since we have used range lookup as true, it returns next largest value that is less than lookup_value (3).

59 thoughts on “VLookup Function – Excel

  1. I’m not sure where you are getting your information, but great topic. I needs to spend some time learning more or understanding more. Thanks for wonderful info I was looking for this information for my mission.

  2. hello!,I love your writing very a lot! percentage we keep up a correspondence more approximately your article on AOL? I need a specialist on this space to solve my problem. Maybe that’s you! Looking ahead to look you.

  3. I have been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all site owners and bloggers made good content as you did, the web will be a lot more useful than ever before.

  4. It’s really a nice and useful piece of info. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.

  5. I have read a few just right stuff here. Definitely price bookmarking for revisiting. I wonder how a lot attempt you place to make this kind of fantastic informative website.

  6. I do not even know how I ended up here, but I thought this post was great. I do not know who you are but definitely you are going to a famous blogger if you are not already 😉 Cheers!

  7. fantastic issues altogether, you just gained a new reader. What would you recommend in regards to your submit that you just made a few days in the past? Any sure?

  8. you are truly a just right webmaster. The website loading pace is incredible. It kind of feels that you are doing any distinctive trick. Also, The contents are masterwork. you have done a wonderful job on this subject!

  9. I have been browsing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. Personally, if all site owners and bloggers made good content as you did, the internet will be a lot more useful than ever before.

  10. What i don’t realize is in reality how you are no longer really much more well-liked than you might be now. You are very intelligent. You already know thus considerably with regards to this topic, made me for my part consider it from numerous numerous angles. Its like women and men don’t seem to be interested until it¡¦s something to accomplish with Girl gaga! Your own stuffs excellent. All the time deal with it up!

  11. of course like your web site however you have to take a look at the spelling on quite a few of your posts. Several of them are rife with spelling problems and I to find it very bothersome to tell the truth nevertheless I’ll certainly come back again.

  12. Thanks, I’ve just been searching for information approximately this subject for a while and yours is the greatest I’ve came upon till now. However, what in regards to the conclusion? Are you certain about the source?

  13. Hi, i think that i saw you visited my blog so i came to “return the favor”.I’m trying to find things to improve my web site!I suppose its ok to use some of your ideas!!

  14. Hiya very nice blog!! Guy .. Excellent .. Amazing .. I’ll bookmark your web site and take the feeds additionally…I am glad to search out so many useful information here in the post, we’d like work out extra strategies in this regard, thanks for sharing.

  15. F*ckin’ amazing issues here. I am very satisfied to peer your post. Thanks a lot and i’m taking a look ahead to touch you. Will you please drop me a e-mail?

  16. Good day very cool site!! Guy .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds additionally…I am satisfied to find a lot of useful information right here in the post, we want develop more strategies in this regard, thanks for sharing.

  17. Hi my family member! I want to say that this article is awesome, great written and come with approximately all vital infos. I’d like to peer extra posts like this.

  18. You could definitely see your skills within the paintings you write. The arena hopes for more passionate writers like you who are not afraid to say how they believe. All the time go after your heart. “Golf and sex are about the only things you can enjoy without being good at.” by Jimmy Demaret.

  19. Thank you for sharing excellent informations. Your web-site is very cool. I am impressed by the details that you’ve on this website. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found just the information I already searched everywhere and simply could not come across. What an ideal site.

  20. Very nice post. I just stumbled upon your weblog and wished to say that I have really enjoyed browsing your blog posts. After all I will be subscribing to your rss feed and I hope you write again soon!

  21. Thanks for the sensible critique. Me & my neighbor were just preparing to do a little research on this. We got a grab a book from our local library but I think I learned more from this post. I am very glad to see such magnificent info being shared freely out there.

  22. Thanks for any other informative blog. The place else could I am getting that type of information written in such a perfect way? I have a project that I am just now running on, and I’ve been at the glance out for such information.

  23. I have not checked in here for some time because I thought it was getting boring, but the last few posts are good quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂

  24. Very nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed browsing your blog posts. In any case I’ll be subscribing to your rss feed and I hope you write again very soon!

  25. naturally like your website however you need to test the spelling on several of your posts. Many of them are rife with spelling problems and I to find it very bothersome to inform the reality then again I¡¦ll definitely come again again.

  26. I really wanted to send a quick comment so as to express gratitude to you for some of the magnificent advice you are giving out at this site. My extensive internet lookup has now been compensated with reasonable facts and strategies to talk about with my family members. I would express that many of us visitors actually are really blessed to dwell in a fine community with many awesome individuals with great techniques. I feel pretty fortunate to have discovered the webpages and look forward to tons of more exciting times reading here. Thanks once more for a lot of things.

  27. I’ve been surfing online more than three hours nowadays, yet I never discovered any attention-grabbing article like yours. It is lovely worth sufficient for me. In my opinion, if all site owners and bloggers made good content material as you did, the web shall be much more helpful than ever before.

  28. I intended to write you that bit of remark to be able to say thanks a lot again with the precious information you have provided on this site. It was simply unbelievably open-handed with you giving extensively precisely what a number of us could have offered for sale as an electronic book to get some bucks for their own end, precisely since you might well have tried it if you ever wanted. Those pointers additionally acted as a good way to know that the rest have the same desire much like mine to understand very much more regarding this issue. I believe there are some more pleasurable moments ahead for those who see your blog.

  29. Somebody necessarily assist to make critically posts I might state. This is the first time I frequented your web page and so far? I surprised with the research you made to create this actual publish incredible. Magnificent process!

  30. Attractive section of content. I just stumbled upon your site and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I will be subscribing to your augment and even I achievement you access consistently quickly.

  31. I have to point out my passion for your kind-heartedness for men and women who should have help on this particular issue. Your personal commitment to passing the message all around came to be pretty beneficial and have in most cases encouraged professionals much like me to arrive at their aims. Your own valuable information denotes this much to me and still more to my colleagues. Many thanks; from all of us.

  32. You could certainly see your enthusiasm within the paintings you write. The sector hopes for even more passionate writers such as you who are not afraid to say how they believe. All the time go after your heart.

  33. I loved as much as you will receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get bought an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly a lot often inside case you shield this hike.

  34. I would like to thnkx for the efforts you have put in writing this blog. I am hoping the same high-grade website post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own web site now. Actually the blogging is spreading its wings rapidly. Your write up is a great example of it.

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2016/11/08/vlookup-function-excel
YouTube49
YouTube