VLOOKUP function

Use VLOOKUP (vertical lookup) when you want to look up a value in a column, and bring back the corresponding value on that row.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Basic example


The above formula looks up the value in cell A1, within the lookup range of B2 through C10, and returns the value in column 2 of the lookup range. FALSE means an exact match will be used.

Problems with VLOOKUP?

More examples

Technical details

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
  • lookup_value Required. The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array. Lookup_value can be a value or a reference to a cell.

  • table_array Required. The range of cells in which the VLOOKUP will search for the lookup_value and the return value. The first column in the cell range must contain the lookup_value (for example, Last Name in the picture below.) The cell range also needs to include the return value (for example, First Name in the graphic below) you want to find. Learn how to select ranges in a worksheet.

  • col_index_num Required. The column number (starting with 1 for the left-most column of table-array) that contains the return value.

  • range_lookup Optional. A logical value that specifies whether you want VLOOKUP to find an approximate or an exact match: TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one. FALSE searches for the exact value in the first column.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum

See also

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.