The LOOKUP function has two syntax forms:
Answer & explanation
Correct answer: option 1
The correct answer is Option (1) → Vector and Array
The LOOKUP function returns a value either from a one-row or one column range or from an array. The LOOKUP function has two syntax forms: vector and array. The Look Up function can be used as an alternative to the IF function for elaborate tests or tests that exceeds the limit for nesting of IF functions.