Excel Chapter 6Online version Vocabulary from Excel Chapter 6 by Melissa Busbin 1 Terms 2 Definition table array HLOOKUP function VLOOKUP function lookup value table arguments return value column index number extract range outline symbols Table Database Record A table of information in which data is looked up. Uses a reference to a range or a range name. 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. 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. The data, or location of the data, you wish to look up. The left column values in a table array. The answer you want to appear as a result of a VLOOKUP function. The column location of the return value within the table array. 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. Symbols that appear beside rows or above columns or data that you wish to group. An organized collection of data. (not database) An organized collection of data. ( not table) The data related to each person or item in a table.
New game