Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Approx Match)

This video tutorial explains the difference between exact and approximate match arguments in VLOOKUP. It demonstrates how to use the approximate match option when the lookup value doesn't exist exactly in the table. The tutorial includes creating a named range for easier reference and constructing the VLOOKUP formula. It also covers using the Functions dialog box to complete the VLOOKUP arguments. The video provides practical examples with salary bands and tax rates to illustrate the concepts.

What is the primary use of the TRUE argument in VLOOKUP?

• To return multiple values from the table

• To find an exact match in the table

• To find an approximate match when the exact value is not present

• To sort the table in ascending order

In the example provided, what is the purpose of creating a named range for the table?

• To make the VLOOKUP formula more complex

• To simplify the process of referencing the table in the formula

• To ensure the table is sorted correctly

• To allow for multiple lookup values

Which column index number is used to return the tax rate in the VLOOKUP example?

• Column #3

• Column #2

• Column #4

• Column #1

What is the advantage of using the Functions dialog box for VLOOKUP?

• It ensures an exact match is found

• It allows for multiple lookup values

• It provides a guided interface to input arguments

• It automatically sorts the table

What is the key difference between VLOOKUP with TRUE and FALSE arguments?

• TRUE finds an exact match, FALSE finds an approximate match

• TRUE sorts the table, FALSE does not

• TRUE returns multiple values, FALSE returns a single value

• TRUE finds an approximate match, FALSE finds an exact match