Explanation of vlookup formula in excel?

Question

Accepted Answer

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

VLOOKUP stands for 'vertical lookup'.
It searches for a value in the first column of a table and returns a value in the same row from a specified column.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and returns the value in the 3rd column.
The last argument [range_lookup] can be either TRUE (approximate match) or FALSE (exact match).

Top HR questions asked in Alldigi Tech Payroll Trainee