Excel vlookup Function


Can anybody help me with Vlookup function.


  Devbrat Tripathi

Vlookup function is used to search a value in the first column of a range and then it goes any cells along rows. It always starts from leftmost column.

Syntax is =vlookup(lookup value, table array, column reference, 0 for exact match and 1 for approximate match)

This function is very interesting when we use it with match, index, if etc.

There are some types of vlookups such as:

vlookup with normal mentioning column number;

vlookup with column function

vlookup with array function.

  Debapriya Bej       05 May 2017       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any