Excel LOOKUP Function

HomeExcel FunctionsExcel LOOKUP Function (Example + Sample File)

What is EXCEL LOOKUP FUNCTION

The Excel LOOKUP Function is listed under Microsoft Excel's Lookup Functions category. It returns a value (which you are looking up) from a row, column, or from an array. In simple words, you can lookup for a value, and LOOKUP will return that value if it’s there in that row, column, or array.

How to use it 

To learn how to use the LOOKUP function in Excel, you need to understand its syntax and arguments:

Syntax

LOOKUP(value, lookup_range, [result_range])

There are two types of LOOKUP functions.

  • Vector Form
  • Array Form

Arguments

  • value: The value that you want to search from a column or a row.
  • lookup_range: The column or row from which you want to lookup for the value.
  • [result_range]: The column or row from which you want to return a value. This is an optional argument.

Notes

  • Instead of using array form it’s better to use VLOOKUP or HLOOKUP.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.