Exceljet

Quick, clean, and to the point

Excel LOOKUP Function

Excel LOOKUP function
Summary 

The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. LOOKUP's default behavior makes it useful for solving certain problems in Excel.

Purpose 
Look up a value in a one-column range
Return value 
A value in the result vector.
Syntax 
=LOOKUP (lookup_value, lookup_vector, [result_vector])
Arguments 
  • lookup_value - The value to search for.
  • lookup_vector - The one-row, or one-column range to search.
  • result_vector - [optional] The one-row, or one-column range of results.
Usage notes 

Note: This page describes the vector form of the LOOKUP function. In this case, a vector refers to a one-column or one-row range.

Use the LOOKUP function to look up a value in a one-column or one-row range, and retrieve a value from the same position in another one-column or one-row range. The lookup function has two forms, vector and array. This article describes the vector form.

LOOKUP has default behaviors that make it useful when solving certain problems (i.e. retrieve approximate matched value instead of position, find the value in the last non-empty cell in a row or column, etc.). LOOKUP assumes that values in lookup_vector are sorted in ascending order and always performs an approximate match. When LOOKUP can't find a match, it will match the next smallest value.

  • LOOKUP assumes that lookup_vector is sorted in ascending order.
  • When lookup-value can't be found, LOOKUP will match the next smallest value.
  • When lookup_value is greater than all values in lookup_vector, LOOKUP matches the last value.
  • When lookup_value is less than all (i.e. the first) value in lookup_vector, LOOKUP returns #N/A.
  • result_vector must be the same size as lookup_vector.
  • LOOKUP is not case-sensitive

Excel Formula Training

Formulas are the key to getting work done in Excel. In this step-by-step training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Start building valuable skills with Excel formulas today. Learn more.

Big fan here! I appreciate all your videos and articles and it helped me become better at Excel, and I keep referring my colleagues to this wonderful website to grow their skills.-Omar
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course