Pinterest Pixel

LOOKUP Formula in Excel

  What does it do? Looks up a value from a table array or one-row / one-column... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

 

What does it do?

Looks up a value from a table array or one-row / one-column range

Formula breakdown:

=LOOKUP(lookup_value, lookup_vector, [result_vector])

What it means:

=LOOKUP(value to be approximately matched, range of values to be matched against, [the matching value to be displayed])


Have you ever tried getting approximate matches in Excel? Approximate matches are used when you have an ascending table like Commission Bonus Rates or Income Tax Rates.

If you have tried out Vlookup Approximate Match in Excel, there is another cool way to do this! You can use the LOOKUP Formula to accomplish this as well.

IMPORTANT: For the LOOKUP Approximate Match to work in Excel, the lookup_vector has to be sorted in ascending order!

So the way that this formula works is that it looks at the first value in the lookup_vector that is greater than the lookup_value and then goes back one value. If a result_vector is provided, then the LOOKUP Formula will get the result from there, otherwise it simply gets it from the lookup_vector.

I explain how you can do this below:

See also  WEEKDAY function: Introduction

LOOKUP Formula in Excel | MyExcelOnline

Download excel workbookLOOKUP-FORMULA.xlsx

STEP 1: We need to enter the LOOKUP function in a blank cell:

=LOOKUP(

LOOKUP Formula in Excel

 

STEP 2: The LOOKUP arguments:

lookup_value

What is the value to be approximately matched?

Select the cell containing the value. In our case, it is the $10,000 income:

=LOOKUP(G8,

LOOKUP Formula in Excel

lookup_vector

Where is the range of values to be matched against?

Now we need to select the range that contains the income values. It should be sorted in ascending order for the LOOKUP Formula to work.

=LOOKUP(G8, C9:C14,

LOOKUP Formula in Excel

result_vector

Where is the range of values to contains the value to be displayed as the final result?

Now we need to select the range that contains the tax rates. This is what we want to display as our final result of the lookup.

=LOOKUP(G8, C9:C14, D9:D14)

LOOKUP Formula in Excel

It was able to find out that the tax rate is 18%!

See also  How to Separate Date and Time in Excel

LOOKUP Formula in Excel

 

How to Use the LOOKUP Formula in Excel

 

 

LOOKUP Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

LOOKUP Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!