Excel FunctionsLesson 119Free preview
VLOOKUP
This lesson is part of Excel · All levels
Summary
VLOOKUP is an Excel search function that looks for values vertically on the first column of a table and returns values from other columns on the same row. The syntax is. This function is very popular for data matching.
Key points
- The search key should be in the leftmost column of the table_array
- Col_index_num is calculated relative to the first column of the table_array
- Range_lookup FALSE for exact search, TRUE for estimate
- The result #N/A means the key is not found or a different data type
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.