Lesson #9: VLOOKUP explained

Lesson #9: VLOOKUP explained

In this post function, VLOOKUP is explained here once more with a very simple example.

VLOOKUP looks for the value in the leftmost column of a table. It means the lookup_value column should be placed on the right side of the array and It will lookup for the value in the leftmost columns of the array.
I have made a simple table for giving an example of VLOOKUP. Now, I have put alphabets in a column, and in another column against those alphabets, I have put some value. I will search the value against any alphabet with VLOOKUP.
  In a cell, I put data validation from the list of alphabets for which I will look for value.

Now, In the above picture, I am showing how to use VLOOKUP. In the very next cell, I have put the formula =VLOOKUP(G3, B3:C16, 2, FALSE). Structure of VLOOKUP is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). This function will lookup for the value in that cell where I specified it as lookup_value then It will search in the array for value in the leftmost columns of the lookup_value column, then it will return the result.

Here this function is showing the result. I hope you like my post. Don’t forget to comment and share it.



Related video tutorials:

See also  Lesson#240: Excel IFERROR Function: Your Guide to Handling Errors Gracefully

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

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

*