Lookup Functions

Question 1

This function picks from a list of options based upon an Index value given to by the user.

Answer 1

=CHOOSE

Question 2

This function scans across the column headings at the top of a table to find a specified item.

Answer 2

=HLOOKUP

Question 3

This function picks a value from a range of data by looking down a specified number of rows and then across a specified number of columns.

Answer 3

=INDEX

Question 4

This function converts a plain piece of text which looks like a cell address into a usable cell reference.

Answer 4

=INDIRECT

Question 5

This function picks out a cell a certain number of cells away from another cell.

Answer 5

=OFFSET

Question 6

This function looks for an item in a list and shows its position.

Answer 6

=MATCH

Question 7

This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows

Answer 7

=TRANSPOSE

Question 8

This function scans down the row headings at the side of a table to find a specified item.

Answer 8

=VLOOKUP

Question 9

This function looks for a piece of information in a list, and then picks an item from the last cell in the adjacent row or column.

Answer 9

=LOOKUP(Array)

Question 10

This function looks for a piece of information in a list, and then picks an item from a second range of cells.

Answer 10

=LOOKUP(Vector)