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)'

🎲 Try a Random Question  |  Total Questions in Quiz: 119  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Microsoft Excel Test — practice the complete quiz, review flashcards, or try a random question.

Microsoft Excel MCQs For LinkedIn Skill Assessments.


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)'