Free Online Tutorials on Spreadsheets

VLOOKUP Function in Excel

Suppose, you have a data table with the following information: student name, ID, total marks and marks obtained. By using the VLOOKUP function, we can look up marks obtained of a student by mentioning his/her ID only.

How the function work?

Step 1
Step 2 [Defining syntax]
Result

When you deal with a huge amount of data, instead of inputting data manually, the VLOOKUP function comes handy because it provides the required value within the shortest period of time.

Syntax

The function has the following arguments in the syntax:

lookup_value – Required. The value to look for in the table. It must be the first column of the table, from which you want the return value i.e. in our example “Marks Obtained”.

table_array – Required. The table from which the VLOOKUP will search for the lookup_value.

col_index_num – Required. The column number containing the return value.

[range_lookup] – Optional. To specify the return value. TRUE = approximate match (default). FALSE = exact match.

Related Topics

Things to remember about VLOOKUP

How to use the LOOKUP function




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved