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)

The correct answer is:

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

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock