Have a Question?

If you have any question you can ask below or enter what you are looking for!



Excel vlookup Function

Hi,

Can anybody help me with Vlookup function.


Thanks        

  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