When you force a lookup function to return an exact match and if it cannot find the one, it returns the #N/A error. Which of the following function allow you to hide errors returned by Lookup function?
Correct Answer: =IFERROR(VLOOKUP(A3,$B$3:$F$99,2,FALSE),"")
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More Excel MCQ Questions