Approximate vs exact match in Excel - Quick Revision & Key Differences

Recall & Review

beginner

What does an exact match mean in Excel lookup functions?

An exact match means Excel looks for a value that is exactly the same as the one you specify, with no differences allowed.

beginner

What is an approximate match in Excel lookup functions?

An approximate match means Excel finds the closest value that is less than or equal to the lookup value, often used with sorted data.

beginner

Which argument in the VLOOKUP function controls exact vs approximate match?

The fourth argument in VLOOKUP, called range_lookup, controls this. Use FALSE for exact match and TRUE (or omit) for approximate match.

intermediate

Why must data be sorted when using approximate match in VLOOKUP?

Data must be sorted ascending so Excel can find the closest smaller value correctly; otherwise, results may be wrong.

beginner

What happens if VLOOKUP with exact match does not find the value?

It returns the #N/A error, meaning the exact value was not found in the lookup range.

In VLOOKUP, what does setting the last argument to FALSE do?

A Returns the first value in the range

B Finds an approximate match

C Sorts the data automatically

D Finds an exact match

Setting the last argument to FALSE tells VLOOKUP to look for an exact match only.

When using approximate match in VLOOKUP, how should your data be arranged?

A Sorted ascending

B Sorted descending

C In any order

D Grouped by categories

Data must be sorted ascending for approximate match to work correctly.

What error does VLOOKUP return if an exact match is not found?

A #N/A

B #REF!

C #VALUE!

D #DIV/0!

VLOOKUP returns #N/A when it cannot find an exact match.

Which of these is true about approximate match in Excel lookup?

A It finds the closest larger value

B It requires sorted data

C It only works with text

D It ignores the lookup value

Approximate match requires the lookup column to be sorted ascending.

If you want to find a price for an exact product code, which match type should you use?

A Either one works

B Approximate match

C Exact match

D No match needed

Exact match ensures you get the price for the exact product code.

Explain the difference between approximate and exact match in Excel lookup functions.

Think about how VLOOKUP behaves with TRUE vs FALSE in the last argument.

Describe when you would use approximate match instead of exact match in Excel.

Consider situations like tax brackets or score ranges.