Question

The type of match to use in a Vlookup() function to assess the resort fee as a possible additional cost for a particular room is: Group of answer choices A fuzzy match An approximate match An exact match None of the answer sections are correct

Answer 1

Answer:

An approximate match

Step-by-step explanation:

The vlookup (vertical lookup) function is a search function in excel used in locating values in an excel table.

The vlookup syntax is written as:

=VLOOKUP(value, table, col_index, [range_lookup])

The range_lookup is an optional parameter which is used to indicate if the search should be for an exact match or approximate match. Since a column, resort fee will be used as a possible additional cost; the search would be required to return an approximate search rather than an exact match in other for the search condition to be adequately implemented.