VLOOKUP function helps you to extract your desired value or data from a range, the range can also be a Excel table.
The structure of the VLOOKUP formula is as follows:
Return value
The matched value from a table.
Syntax
=VLOOKUP (value, table, col_index, [range_lookup])
Arguments
value – The value to look for in the first column of a table.
table – The table from which to retrieve a value.
col_index – The column in the table from which to retrieve a value.
range_lookup – [optional] TRUE = approximate match (default). FALSE = exact match.
VLOOKUP is a very commonly used function in many industries for many purposes. Knowing this function will take you to the next level in you reporting / automation career.
Trust me, some of my friends got job just by knowing this function.
This video tutorial explains the basics of VLOOKUP function and its arguments in a simplest manner.
Leave a Reply