Question: Which VLOOKUP function, 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?
- `=VLOOKUP(A2,J2:L5,1,FALSE)`
- `=VLOOKUP(J2,A$2:C$7,1,FALSE)`
- `=VLOOKUP(J2,A$2:C$7,3,FALSE)`
- `=VLOOKUP(J2,A2:C7,3,FALSE)`
Answer: The correct answer of the above question is Option C:`=VLOOKUP(J2,A$2:C$7,3,FALSE)`