In the worksheet shown below, cell C6 contains the formula=VLOOKUP(A6,$F$2:$G$10,2,FALSE). What is the most likely reason that #N/A is returned in cell C6 instead of mallory’s ID (2H54)

  • The absolute/relative cell references in the formula are wrong
  • Cell A6 is not actualy text its a formula that need to be copied and pasted as a value
  • Column C in the lookup range is not sorted properly
  • A trailing space probably exist in cell A6 or F7

The correct answer is:

  • A trailing space probably exist in cell A6 or F7

🎓 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