*'''Column''' is the column number in the table from which the matching value should be returned, and
*'''Column''' is the column number in the table from which the matching value should be returned, and
*'''ApproximateMatchFlag''' is an optional logical value that specifies whether to find an exact match or approximate match of the mentioned lookup value.
*'''ApproximateMatchFlag''' is an optional logical value that specifies whether to find an exact match or approximate match of the mentioned lookup value.
−
+
**VLOOKUP(), looks in the first column of an array and moves across the row to return the value of a cell.
−
VLOOKUP(), looks in the first column of an array and moves across the row to return the value of a cell.