Can anybody help me with Vlookup function.
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