Question: 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)`

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

Answer: The correct answer of the above question is Option D:A trailing space probably exist in cell A6 or F7