Question

In cell C24, enter a lookup function that looks up the value of cell A24, from the range named "SurveyRange," to supply the score found in column 3.

a) =VLOOKUP(A24, SurveyRange, 3, FALSE)
b) =LOOKUP(A24, SurveyRange, 3)
c) =INDEX(SurveyRange, A24, 3)
d) =MATCH(A24, SurveyRange, 3)

Answer 1

Option (A), The correct formula to use for looking up a value in the 'SurveyRange' and returning the score from the third column is =VLOOKUP(A24, SurveyRange, 3, FALSE). This function searches the first column of the range for the exact value of cell A24 and returns the corresponding value from column 3.

Step-by-step explanation:

The question refers to using a lookup function in a spreadsheet program like Microsoft Excel. When you need to look up the value of cell A24 in a range named SurveyRange and return the score from column 3 of that range, the correct formula to use is =VLOOKUP(A24, SurveyRange, 3, FALSE).

This formula uses the VLOOKUP function, which stands for 'Vertical Lookup'. It searches for the value of cell A24 in the first column of the SurveyRange. Once it finds a matching value, it returns the value in the same row from the third column. The FALSE parameter at the end of the formula specifies that you want an exact match for the lookup value.

The LOOKUP and MATCH functions do not provide the same functionality for this particular case. The INDEX function does not work with the specified parameters, and would require a row number instead of A24 as the second argument.