LinkedIn Microsoft Excel Certification

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)

October 29, 2022 Editorial Staff

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