Skip to content

Explain Array form of… (Class 12 Accountancy 2026, Q33b)

questionbuddy.in/q/cbse-12-accountancy-2026-67-5-1-q33b-array-form-lookup-function

AccountancyCBSE Class 12 · Board exam 2026, set 67/5/1 · 4 marks · Long answer

CBSE Class 12 Accountancy 2026: question 33(b)

Set in the CBSE Class 12 board exam of 2026, paper 67/5/1, section B-II, question 33(b), for 4 marks. Try it first; the hints and our step-by-step solution are below.

Q33(b) · 4 marks · Long answerUse of Spreadsheet in Business Applications

Explain Array form of LOOKUP function.

Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/5/1.

Hints

Open one hint at a time and try again before the next.

Hint 1

The array form takes just two arguments.

Hint 2

What does LOOKUP return if the exact value is missing?

Hint 3

The shape of the array decides whether it searches a row or a column.

Step-by-step solution

Each step shows the marks it earns, as an examiner would award them. Checked by an independent re-solve from the question paper.

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

    1 mark

  2. Syntax: LOOKUP(lookup_value, array). lookup_value can be a number, text, logical value or a name; array is the range of cells to search.

    1 mark

  3. If LOOKUP cannot find lookup_value, it uses the largest value in the array that is less than or equal to it; if lookup_value is smaller than the smallest value in the first row or column, it returns #N/A.

    1 mark

  4. If the array is wider than it is tall, LOOKUP searches the first row; if it is square or taller than wide, it searches the first column.

    1 mark

Answer: LOOKUP(lookup_value, array) searches the first row or column of the array and returns the matching position from the last row or column; nearest smaller value if no exact match, #N/A if below the smallest

Where the marks are

  • Meaning (1 mark)
  • Syntax and arguments (1 mark)
  • Behaviour when no exact match (1 mark)
  • Row versus column search (1 mark)

Revise the chapter

Practise this chapterBoard-style questions from Use of Spreadsheet in Business Applications, one at a time, marked against the answer key and marking points.Back to the full paper2026 board paper, set 67/5/1: every question, by section.

The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error? Write tosupport@questionbuddy.in.