Which VLOOKUP formula in MS-Excel, when entered into cell L2 and then dragged to cell L5, returns the average number of calls for the representative IDs listed in column J?

A= VLOOKUP(A2, J2:L5, 1, FALSE)

B= VLOOKUP(J2, A$2:C$7, 1, FALSE)

C= VLOOKUP(J2, A$2:C$7, 3, FALSE) ✓ Correct

D= VLOOKUP(J2, A2:C7, 3, FALSE)

Correct answer: (C) = VLOOKUP(J2, A$2:C$7, 3, FALSE)

Explanation

Entering VLOOKUP(J2, A$2:C$7, 3, FALSE) looks up each rep ID from column J and returns the average calls held in the third column.

The dollar signs lock the lookup range A$2:C$7 so it stays fixed as the formula is dragged down to L5.

The column index 3 points to the average-calls column, giving the value actually wanted.

A column index of 1 would only return the ID itself, not the average calls.

A range without absolute references, A2:C7, would shift downward on dragging and miss rows.

The final FALSE forces an exact match on the representative ID.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.