How to use Excel's VLOOKUP-function

VLOOKUP-function is a great help when you need to find data from the large tables. With VLOOKUP you can search for a value in the first column of the table and return a value in the same row from the column you specify. VLOOKUP has three mandatory parameters and one optional parameter:

1. parameter: Value to search in the first column
2. parameter: Table to search from
3. parameter: Index of the column from which the matching value must be returned. The index of the first column is 1
4. optional parameter: If omitted or TRUE, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will only find an exact match.

The following video demonstrates a simple example how to use VLOOKUP: