Vlookup function

Description

This VLOOKUP function perform lookup and retrieve data from a specific column in a table. The "V" stands for "vertical", where is lookup the values appear in the first column of the table, lookup column to the right. VLOOKUP supports approximate and exact matching and close matches.

​

Objective

Obtain value in a table by matching on the first column.

​

Syntax

=VLOOKUP(value,table,row_index,[range_lookup])

​

Arguements

value - Value to lookup.

table - Table from which to retrieve data.

row_index - Row number from which to retrieve data.

range_lookup - [optional] Boolean to indicate exact match of close match. Default is True = close match.