Vlookup Function Syntax. Vlookup function is used to search a value in the first column of a range of cells and then return a respective value from any cell on the same row of the range. The range where the lookup value is located.
The column number in the range that contains the return value. To make this two way lookup formula you need to make the column dynamic as well. Vlookup function is used to search a value in the first column of a range of cells and then return a respective value from any cell on the same row of the range.
Vlookup lookup value table array col index num range lookup as you see the function has 4 arguments the first three are requited and the last one is optional.
The column number in the range that contains the return value. False exact match. It must be in the first column of lookup table. The syntax for the vlookup function is as follows.
