The LOOKUP function has two syntax forms:
The LOOKUP function has two syntax forms:
Solution
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.
Related questions:
2022: 30 Aug Shift 2
2025: 30 May Shift 1
2026: 6 June Shift 1
2025: 30 May Shift 2
2025: 27 May Shift 1