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:

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

## =LOOKUP(

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_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.

## 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)

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

How to Use the LOOKUP Formula in Excel

### HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin