BInterest

In Excel 2007, VLOOKUP Function search for a value in the 1st column of the table in study and returns the corresponding value in the same row from another column in table in study in the Vertical Direction. VLOOKUP FUNCTION can be used when you are in need of the searching the specific value for the corresponding reference in the huge data base.

Syntax : VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

VLOOKUP Function Syntax :

• lookup_value : It is the Value to be searched in the 1st column of the table in study.
• table_array : Table in study (combination of 2 and more columns & rows)
• col_index_num : It is the column number, in the table for which the corresponding value in the lookup_value row is required.
• range_lookup : It is a logical parameter, that specifies between exact match of the lookup_value in the corresponding column or approximate value (It can be defined as TRUE OR FALSE) OR (1 OR 2) in the Formula.

VLOOKUP Function Via Example :

• Lets look at the Reference Sheet  below which have the table_array, so called table in study for understanding the VLOOKUP

• Based on the VLOOKUP-REFERENCE SHEET, we would like to calculate the zone data using the VLOOKUP FUNCTION in the VLOOKUP-FORUMLA SHEET below.

• =VLOOKUP(B15,’VLOOKUP-REFERENCE’!$B$3:$E$24,2,FALSE) is the syntax for the VLOOKUP FUNCTION USED IN THE ABOVE EXAMPLE.
• lookup_value : B15 (EAST) What to lookup East in the Reference Sheet and get the corresponding Value.
• table_array : B3 TO E24 is the selection or table in study
• col_index_num : 2 (2nd Column) to get the data for the label AA in the selected table.
• range_lookup : As it is the text which we want to lookup, we would be in need of the exact value corresponding to EAST in the 2nd Column in the Same Row, that is why it is TRUE.

Possible Results of Same VLOOKUP Function :

1. =VLOOKUP(B15,’VLOOKUP-REFERENCE’!$B$3:$E$24,2,FALSE) would return 6300.3
2. =VLOOKUP(B16,’VLOOKUP-REFERENCE’!$B$3:$E$24,3,FALSE) would return 28.7
3. =VLOOKUP(B17,’VLOOKUP-REFERENCE’!$B$3:$E$24,4,FALSE) would return 12.9
4. =VLOOKUP(B17,’VLOOKUP-REFERENCE’!$B$3:$E$24,4,TRUE) would return 1701.5

You can follow me on Twitter at http://twitter.com/binterest.Do stay tuned to Binterest.com for more, Best Way 2 do it, Subscribe to Binterest's Feed Updates