lookup value
The column location of the return value within the table array.
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.
The data related to each person or item in a table.
Database
The left column values in a table array.
VLOOKUP function
HLOOKUP function
Table
return value
The answer you want to appear as a result of a VLOOKUP function.
A table of information in which data is looked up. Uses a reference to a range or a range name.
table arguments
table array
outline symbols
column index number
Range in which Excel copies the records that meet the comparison criteria in the criteria range in a search or filter to another part of the worksheet.
The data, or location of the data, you wish to look up.
Record
Symbols that appear beside rows or above columns or data that you wish to group.
One of the lookup and reference functions to be used when you need to find things in a table or a range by row. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
extract range
An organized collection of data. (not database)
An organized collection of data. ( not table)