How to VLOOKUP in Excel 2013

In this article, you’ll learn how to VLOOKUP in Excel 2013. VLOOKUP function is one of the powerful Excel functions. You can use VLOOKUP function to find values of cells in a range or a table by row.

For example, you have a list of items (item number, item name, and prices) and you want to find the item name and price of each item by item number. In this case, you can use VLOOKUP function to achieve it.

VLOOKUP(value, table, column_index, [range_lookup])

  • value: It’s the value that you want to look up (lookup value).
    The lookup value must be in the first column in the range that you specify in the table.
  • table: It’s the range of cells in which the VLOOKUP will search for the value that you want to look up.
  • column_index: It’s the column number that contains the return value.
  • range_lookup: It’s a logical value (TRUE or FALSE). FALSE is an exact match. TRUE is an approximate match. range_lookup is optional.

*Note: Column number starts with 1 for the left-most column of table. TRUE  will be default if you don’t specify a logical value.
– For example, VLOOKUP(“Game”, B2:E4 , 2, FALSE).

How to VLOOKUP in Excel 2013

Search for the price of “Book“.

In this example, table spans cells B3:C13, thus lookup_value must be in B column and co_index_num is 2. In this example, we want to search exact match, thus range_lookup is FALSE.

To VLOOKUP, we just type =VLOOKUP and add its’ required arguments in any blank cell that we want to return the result.

We want to search for the price of “Book” in this example. We can see that “$30” is the price of “Book” because this example contains simple data thus we can see easily. It will be difficult for us to look for the price of the item in a large data.

Excel VLOOKUP function is one of the powerful Microsoft Excel function that let you search for values of cells in Microsoft Excel spreadsheets. It’s very useful Excel function for searching in the large and complex Excel spreadsheets.

This article, you learned how to VLOOKUP in Excel 2013.