✓ 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.
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 forms of 'Lookup' function.2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.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 it.2025
- From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.