Detail Explanation of VLookup Usage (Advance Excel)

Let start sharing with the detail explanation of VLookup command in Advance Excel, there are many advance formulas in MS-Excel 2007, by proper using of these formulas anyone can compile many types of reports.

VLookup command is very useful command, by using this command you can easily sought out your required data in specific field. I will share conditionally use of VLookup command in next post. 

I will try to share my details in a easy way step-by-step.

Let’s start:

First of all everyone must have the idea the what is the main operation of VLookup command, so listen, VLookup is a command that can easily find out the value as you want against a specific value from a table rows. VLookup only sought out the value in a defined not column, not the whole table.

For example: If we want that when we type “Entertainment” in any cell of MS-Excel then the next cell show the “Plateform”, so we can do the following practice.

Syntax of VLookup command is.

Vlookup (.lookup_value, .table_array, .col_index_num, .[range_lookup]

Briefing of syntax

Vlookup = is the name of command

lookup_value = that is the focusing value, suppose you typed “Entertainment”, as I show in above example.

table_array = this is the array of table from which you want to find the value of “Entertainment” (Note: It is compulsory that the start column of your table array is that column which has “Entertainment”).

col_index_num = this is the number of your column, from where your field is acquired (suppose your table has 8 columns and there is the 6th column have your required field then you type in 6)

[range_lookup] = this is drop-down list, it has two options. 1. True, 2 False.

True is use for approximate match

False is use for exact match

Please view the below snap, how a vlookup command work.

Above example I have using only two columns table, but there can be more columns table on that time you do the same using of this formula just change the table array (your table cells range) and also change the col_index_num, this is a very simple but very useful formula of MS-Excel. You can design a small sheet where you just simply type a word and then result is come from your backup table array. This formula can all the excel user for make them more expert. I will share more ideas of using vlookup with other formulas in next posts. For get more ideas revisit my blog and also don't forget to share with your friends or if anyone has any query so contact with me. Thanks.