Excel Lookup Functions Quiz

Which function is used to look up a value vertically in a table in Excel?

• HLOOKUP

• VLOOKUP

• XLOOKUP

• MATCH

What is the default lookup value type for VLOOKUP?

• Approximate match

• Exact match

• Exact match or approximate match depending on the data

• No match

In VLOOKUP, what does the fourth argument (range_lookup) control?

• The column index to return the result from

• Whether the lookup is exact or approximate

• The table range to search

• The row number to return

What happens if VLOOKUP cannot find an exact match, and the range_lookup is set to FALSE?

• It returns the closest match

• It returns an error (#N/A)

• It returns the first match

• It returns 0

In which of the following cases would you use HLOOKUP instead of VLOOKUP?

• When you need to look up a value in a row

• When you want to search for values horizontally across columns

• When your table is organized by columns

• When your table is organized by rows

Which function can replace both VLOOKUP and HLOOKUP in Excel?

• XLOOKUP

• INDEX

• OFFSET

• MATCH

What is the main advantage of XLOOKUP over VLOOKUP?

• XLOOKUP allows you to search data horizontally

• XLOOKUP can search in both directions (left-to-right and right-to-left)

• XLOOKUP doesn’t require an exact match

• XLOOKUP is used for data validation

The syntax of XLOOKUP is:

• =XLOOKUP(lookup_value, lookup_array, return_array)

• =XLOOKUP(lookup_value, return_value, lookup_array)

• =XLOOKUP(lookup_value, lookup_array, match_value)

• =XLOOKUP(lookup_value, lookup_array, result_array, match_type)

What does the "if_not_found" argument in XLOOKUP return?

• A value of 0 if no match is found

• An error (#N/A)

• A custom value (e.g., "Not Found") if no match is found

• A message with the formula error

What happens if the "match_type" argument in XLOOKUP is set to 1?

• It finds an exact match or the next smaller value

• It finds an exact match or the next larger value

• It finds the first matching value

• It finds the last matching value