✓ Board-verified
Accountancy · 2025 · 6 marks
CBSE 2025 · Region 2 · Set 3 · Q34
Which function can be used as an alternate to the 'IF' function for elaborate test and why ? Give the meaning of its types with their syntax.
Marking-scheme solution
LOOKUP function can be used as an alternative to 'IF' function for elaborate tests that exceed the
time + for nesting of IF Function LOOKUP function has two forms.
(1)
Vector form
(2)
Array form
Vector form
V. LOOKUP (Lookup_value, Lookup_vector, result_vector)
§ Lookup_value is a value that LOOKUP searches for in the first vector. It can be number, text, a logical
value or a name etc.
Lookup_vector is a range that contains only one row or one column
§
Lookup result is a range that contains only one row or column. It must be the same size as
§
lookup_vector array form
LOOKUP (Lookup_value, array).
§ Lookup_value is the value that LOOKUP searches for in an array-It can be a number, text, a logical
value, or a name or reference that refers to a value.
§ Array is a range of cells that contains text, numbers logical values that we want to compare with
lookup_value.
More from Spreadsheet
- Explain the two syntax f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.