In this post function VLOOKUP explained here once more with a very simple example.
In 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 as lookup_value then It will search in the array for value in leftmost columns of the lookup_value column, then it will return the result.
Here this function is showing result. I hope you like my post. Don’t forget to comment and share it.
Related video tutorials: