Excel Chapter 3B: The VLOOKUP Function

approximate match

A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table.

Grades or salaries that fall within a range will require a/an ____ match.

Approximate.

Names, ID numbers, or part numbers will require a/an ____ match.

Exact.

lookup functions

Functions are used to find information stored in a table in an Excel worksheet

range_lookup

an argument that determines how the VLOOKUP and HLOOKUP function handle lookup values that are not an exact match for the data in the lookup table

table_array

defines the location of the reference table

VLOOKUP function

looks up a value in a vertical lookup table and returns a related result from the lookup table

lookup_value

refers to the information that will use to pull a value from the reference table

col_index_num

the column in the table that contains the information you wish to have returned

exact match

the value in the specified field must match the condition exactly in order for the record to be included in the query results