LOOKUP Function in Excel: Syntax, Examples and Free Practice
LOOKUP is an Excel Lookup & Reference function. A simpler, older lookup formula — requires sorted data.
LOOKUP syntax
Arguments
lookup_value: The value you are searching forlookup_vector: The single row or column to searchresult_vector: The single row or column to return a value from (optional)
When to use LOOKUP
LOOKUP is used to pull matching data from one part of a workbook into another.
Practice LOOKUP online, free
Open the live Excel-style spreadsheet and try LOOKUP yourself. No Excel install or sign-up needed to start.
Practice LOOKUP now →More Lookup & Reference functions
Frequently asked questions
What does the LOOKUP function do in Excel?
A simpler, older lookup formula — requires sorted data.
What is the syntax of LOOKUP in Excel?
The syntax is =LOOKUP(lookup_value, lookup_vector, [result_vector]). lookup_value: The value you are searching for; lookup_vector: The single row or column to search; result_vector: The single row or column to return a value from (optional).
Where can I practice LOOKUP online for free?
Open the free live spreadsheet on Cellgrids and try LOOKUP yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts