top of page


VLOOKUP is an incredibly popular and useful function in Excel that allows us to search for a value in a table and retrieve a corresponding result.

To put it in a real-life context, think of the "Contacts" app on your phone. When you search for a friend's name, the app returns their phone number. This is essentially what VLOOKUP does!

The VLOOKUP function in Excel is structured as follows: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Here's a breakdown of the parameters:

  • lookup_value: This is the value we are searching for, which can be a text, number, or a reference to a single cell.

  • table_array: It refers to the range where we will perform the lookup, containing both the value we are searching for and the corresponding result. It's important to note that the range should begin from the column containing the value and include the column where the desired result is located.

  • col_index_num: This specifies the column number from which we want to retrieve the result. The number should be relative to the first column in the selected range within the table_array.

  • [range_lookup]: This optional argument determines the type of lookup to perform. By default, it is set to 0 (or FALSE), indicating an "Exact Match" – it will find the exact value we are looking for. If we want an "Approximate Match," we can use 1 instead.

Remember, it's generally recommended to use 0 (or FALSE) for [range_lookup] to ensure an exact match.

bottom of page