What is VLOOKUP in Excel and how to use it (practically)?

Question

Accepted Answer

VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.

Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: the value to search for in the first column of the table
table_array: the range of cells that contains the table
col_index_num: the column number in the table from which to return a value
range_lookup: optional argument that specifies whether to find an exact match or an approximate match
Example: =VLOOKUP(A2, B2:C10, 2, FALSE) - searches for the value in cell A2 in the first column of the range B2:C10 and returns the corresponding value from the second column
VLOOKUP can be used for tasks such as merging data from different tables or finding specific information in a large dataset

Top Indian Oil Corporation Industrial Trainee interview questions & answers