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