The LOOKUP function has two syntax forms:

Vector and Array

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.