HomeTestsSearchRankProfile
easyMCQCUET Accountancy 2025 27 May Shift 22026Accountancy
1 mark

The LOOKUP function has two syntax forms:

  1. A
    Vector and Array
  2. B
    AND and OR
  3. C
    TRUE and FALSE
  4. D
    IF and BLANK

Solution & Step-by-step Explanation

In modern spreadsheet tools (like MS Excel and Google Sheets), the LOOKUP data function can be utilized in either of two standard layout syntax configurations: the Vector form or the Array form.

Practice this question

Try it yourself before checking the explanation above.

The LOOKUP function has two syntax forms:
A
Vector and Array
B
AND and OR
C
TRUE and FALSE
D
IF and BLANK

Share This Question

Related Questions

Ready for a Full Test?

Practice with timed mock tests and track your performance across Accountancy.

Discussion