Question:
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, B3:F10, 2, 0) - 100)
(iii) = VLOOKUP(B2, B3:F10, 5, 0)
(iv) = VLOOKUP(B3, B3:B10, 2, 0)
(v) = VLOOKUP(B6, B3:F10, 0, 0)
(vi) = VLOOKUP(B6, B3:F10, 2, 0)/0
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, B3:F10, 2, 0) - 100)
(iii) = VLOOKUP(B2, B3:F10, 5, 0)
(iv) = VLOOKUP(B3, B3:B10, 2, 0)
(v) = VLOOKUP(B6, B3:F10, 0, 0)
(vi) = VLOOKUP(B6, B3:F10, 2, 0)/0
(i) = VLOOKUP(B5, C3:F10, 2, 0)
(ii) = SQRT(VLOOKUP(B3, B3:F10, 2, 0) - 100)
(iii) = VLOOKUP(B2, B3:F10, 5, 0)
(iv) = VLOOKUP(B3, B3:B10, 2, 0)
(v) = VLOOKUP(B6, B3:F10, 0, 0)
(vi) = VLOOKUP(B6, B3:F10, 2, 0)/0
Show Hint
Ensure the lookup value is in the first column of the table array. Use a valid column index that corresponds to the structure of the table array. Avoid dividing by zero or referencing incorrect ranges in formulas.
Updated On: Jan 13, 2026
Show Solution
Verified By Collegedunia
Solution and Explanation
Was this answer helpful?
0
0
Top CBSE CLASS XII Accountancy Questions
From the following Balance Sheet of Hira Ltd. as at 31st March, 2023, prepare Comparative Balance Sheet:
- On 1st May, 2023, Amrit Ltd. issued 10,000, 10% debentures of ₹100 each at a premium of 10%, redeemable at a premium of 10%. Loss on issue of debentures will be:
- Gupta and Sharma are partners in a firm sharing profit in the ratio of 4:1. They admitted Preeti as a new partner for \( \frac{1}{4} \) share in the profits, which she acquired wholly from Gupta. The new profit sharing ratio of Gupta, Sharma, and Preeti will be:
- On the dissolution of a partnership firm, there were debtors of ₹34,000. Debtors of ₹1,000 became bad, and 60% was realized from the remaining debtors. Which account will be debited and by how much amount on the realization from debtors?
- If vendors are issued fully paid shares of ₹1,25,000 in purchase consideration of net assets of ₹1,50,000, the balance of ₹25,000 will be credited to:
View More Questions
Top CBSE CLASS XII Cash Flow Statement Questions
- From the following details, calculate Cash Flow from Investing Activities: - Purchase of Machinery Rs 1,50,000
- Sale of Land Rs 80,000
- Purchase of Investments Rs 50,000
- Interest received Rs 8,000
- Which of the following transactions will result in ‘Cash Flows from Operating Activities’?
- ‘Sale of Patents’ will result in:
- Statement I: Sale of marketable securities will result in flow of cash.
Statement II: Cash flow implies movement of cash in and out due to some non-cash items.
Choose the correct option from the following: From the following information extracted from the books of Kant Ltd., calculate ‘Cash Flows from Operating Activities’.
View More Questions
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is
View More Questions