Question

Harrison has to find the value in a large worksheet that is at the intersection of a column and row. Which function should he use?

O INDEX
O HLOOKUP
O VLOOKUP
O MATCH

Answer 1

Harrison should use the INDEX function to find a specific value at the intersection of a row and column in a large worksheet. Unlike HLOOKUP or VLOOKUP which search for values, INDEX directly returns the value at the specified intersection.

Step-by-step explanation:

Harrison should use the INDEX function to find a value at a specific intersection of a column and row in a large worksheet. This function allows you to select an element from a range by specifying the row and column number. For example, if Harrison has a table of data and he knows the row and column number where his desired value is located, he can use INDEX(range, row_num, column_num) to retrieve it.

While functions like HLOOKUP and VLOOKUP search for a value in the first row or column of a table and return a value in the same column or row, INDEX function directly targets the intersection point. The MATCH function, on the other hand, would only return the position of a specified item within a range, not the value itself. Therefore, for finding a specific value at a row and column intersection, INDEX is the appropriate choice.