Your Guide on Using the Excel LOOKUP Function

Excel’s LOOKUP function allows users to do a cross-match in a single row or column after which a matching value is returned from a different row or column. The reason for using the LOOKUP function in excel is to “look up” certain values in a one-column or row range.

LOOKUP Syntax 1 (Formula)

=LOOKUP(lookup_ value, lookup_range, [result_range])

Here, the LOOKUP function performs a search for one value in the look_up range and returns the corresponding value in the result_range that appears in the same one-row or one-column.

What each parameter/argument means

Lookup_value refers to the value we’re searching for in the lookup_range.

Lookup_range refers to one-column or one-row where the search is performed.

Result_rangeit is optional and refers to the one-row or one-column where the value (also known as results) are returned.

LOOKUP Syntax 2 (Formula)

NB: note that this is an array function

=LOOKUP(value, array)

What each parameter/argument means

value – refers to the “value” that is being searched. One must bear in mind that the values are arranged in ascending order.

Array – refers to the “array” which includes all values.

However, in this article, we would consider the vector function for our example.

Example of the LOOKUP function

First, we must note that the LOOKUP function is a Worksheet function (WS) in Excel. Now, let’s consider the excel spreadsheet below-containing parameters of different cars.

Figure 1. Excel Spreadsheet with values.

Based on the Excel spreadsheet, entering the formula =LOOKUP(1200, A1:A6, B1:B6)gives us what we have in the spreadsheet below:

Figure 2: Excel LOOKUP function returns the corresponding value.

Notes

  • The Excel LOOKUP function usually returns the biggest value in the “lookup_range” when it can not find a similar match.
  • When the returned value is less than all the values in the “lookup_range,” the value (or error) returned by the LOOKUP function is #N/A.

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar