What error code is returned by an MS Excel cell formula if a required lookup value cannot be matched or found inside a VLOOKUP search block? MCQ with Answer and Explanation
What error code is returned by an MS Excel cell formula if a required lookup value cannot be matched or found inside a VLOOKUP search block?
A. #N/A
B. #VALUE!
C. #NAME?
D. #REF!
Answer: Option A
Solution (By JKSSB Mock Tests)
The #N/A (Not Available) error occurs when a formula or function cannot locate the target data requested, such as an exact match lookup missing from a reference table.
No comments yet. Be the first to start the discussion!