Skip to main contentSkip to solution

The LOOKUP function has two syntax forms:

Solution

✅ Correct Option: 1

The LOOKUP function in spreadsheet applications has two syntax forms: Vector form and Array form.

Vector form searches for a value in a single row or column (called a vector) and returns a corresponding value from another row or column at the same position.

Array form searches for a value in the first row or column of an array and returns a value from the last row or column in the same array.

Option 2 (AND and OR) are logical functions, not syntax forms of LOOKUP.

Option 3 (TRUE and FALSE) are logical values used in functions like IF, not syntax forms of LOOKUP.

Option 4 (IF and BLANK) - IF is a separate logical function and BLANK is not a syntax form.

Therefore, Option 1 is correct as it correctly identifies the two syntax forms of the LOOKUP function.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question