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?
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.
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.