Using the worksheet, find out the error and its reason for the given `VLOOKUP` syntax:
\[
\begin{array}{|c|l|c|c|}
\hline
\textbf{S. No.} & \textbf{Consumables} & \textbf{Price in FY 21-22 (₹)} & \textbf{Price in FY 23-24 (₹)} \\
\hline
1 & \text{Pineapple} & 40 & 55 \\
\hline
2 & \text{Kiwi} & 34 & 45 \\
\hline
3 & \text{Jackfruit} & 50 & 62 \\
\hline
4 & \text{Blueberry} & 35 & 54 \\
\hline
5 & \text{Butter} & 50 & 56 \\
\hline
6 & \text{Buns} & 48 & 45 \\
\hline
7 & \text{Meat} & 36 & 48 \\
\hline
\end{array}
\]
Worksheet data for VLOOKUP syntax
Show Hint
Solution and Explanation
1. Formula: \[ =VLOOKUP(B1, B4 : D6, 2, 0) \]
Reason: The reference range used in this formula (B4:D6) does not include the entire data set. The range should start from the top row of the table (e.g., B1:D7) for proper referencing.
2. Formula: \[ =SQRT(VLOOKUP(C2, C2 : D8, 2, 0) - 100) \]
Reason: The VLOOKUP function is trying to search for the value in C2 within the range C2:D8, which results in an invalid range. The lookup value should exist within a different range.
3. Formula: \[ =VLOOKUP(B5, B6 : D8, 1, 0) \]
Reason: The 1st column index (A) does not exist in the lookup range (B6:D8). The first column should be in the lookup range for the formula to work properly.
4. Formula: \[ =VLOOKUP(B3, B2 : D5, 5, 0) \]
Reason: The column index (5) exceeds the available columns in the specified range (B2:D5). The column index should be less than or equal to the number of columns in the range.
5. Formula: \[ =VLOOKUP(B5, B3 : D8, 0) \]
Reason: The column index (0) is invalid. The column index must be a positive integer that corresponds to a column number within the given range.
6. Formula: \[ =VLOOKUP(B2, B2 : D7, 2, 0) \]
Reason: This error occurs if the lookup value (B2) does not exist in the first column of the specified range. Ensure the lookup value is available in the range for a correct lookup.
Top Questions on Miscellaneous
- "ASEAN took steps to establish an ASEAN community on the basis of its three pillars." Explain the importance of these three pillars.
- CBSE CLASS XII - 2025
- Political Science
- Miscellaneous
- If the system of equations \[ x + 2y - 3z = 2 \] \[ 2x + \lambda y + 5z = 5 \] \[ 4x + 3y + \mu z = 33 \] has infinite solutions, then \( \lambda + \mu \) is equal to
- JEE Main - 2025
- Mathematics
- Miscellaneous
- If the square of the shortest distance between the lines $$ \frac{x-2}{1} = \frac{y-1}{2} = \frac{z+3}{-3} \quad \text{and} \quad \frac{x+1}{2} = \frac{y+3}{4} = \frac{z+5}{-5}, $$ is $ \frac{m}{n} $, where $m, n$ are coprime numbers, then $m+n$ is equal to:
- JEE Main - 2025
- Mathematics
- Miscellaneous
- Find the value of \[ \sin 70^\circ \left( \cot 10^\circ \cot 70^\circ - 1 \right). \]
- JEE Main - 2025
- Mathematics
- Miscellaneous
- What is the shape of the \( \text{ClO}_2^- \) ion according to VSEPR theory?
- JEE Main - 2025
- Chemistry
- Miscellaneous
Questions Asked in CBSE CLASS XII exam
- A bilobed dithecous anther has 200 microspore mother cells per microsporangium. How many male gametophytes can be produced by this anther?
- CBSE CLASS XII - 2025
- Development of male and female gametophyte
- A beam of light coming from a distant source is refracted by a spherical glass ball (refractive index 1.5) of radius 15 cm. Draw the ray diagram and obtain the position of the final image formed.
According to the generally accepted definition of the ideal solution there are equal interaction forces acting between molecules belonging to the same or different species. (This is equivalent to the statement that the activity of the components equals the concentration.) Strictly speaking, this concept is valid in ecological systems (isotopic mixtures of an element, hydrocarbons mixtures, etc.). It is still usual to talk about ideal solutions as limiting cases in reality since very dilute solutions behave ideally with respect to the solvent. This law is further supported by the fact that Raoult’s law empirically found for describing the behaviour of the solvent in dilute solutions can be deduced thermodynamically via the assumption of ideal behaviour of the solvent.
Answer the following questions:
(a) Give one example of miscible liquid pair which shows negative deviation from Raoult’s law. What is the reason for such deviation?
(b) (i) State Raoult’s law for a solution containing volatile components.
OR
(ii) Raoult’s law is a special case of Henry’s law. Comment.
(c) Write two characteristics of an ideal solution.- CBSE CLASS XII - 2025
- Solutions
- Kajal and Laura were partners in a firm sharing profits and losses in the ratio of 5:3. They admitted Maddy for \( \frac{1}{4} \)th share in future profits. Maddy brought Rs 8,00,000 as his capital and Rs 4,00,000 as his share of premium for goodwill. Kajal, Laura and Maddy decided to share profits in future in the ratio of 2:1:1. After all adjustments in respect of goodwill, revaluation of assets and liabilities etc. Kajal's capital was Rs 15,00,000 and Laura's capital was Rs 8,00,000. It was agreed that partners' capitals should be in proportion to their new profit sharing ratio taking Maddy's capital as base. The adjustment was made by bringing in or withdrawing the necessary cash as the case may be. The cash brought in by Kajal was:
- CBSE CLASS XII - 2025
- Partnership
- Parents want their children to excel in academics and due to this physical activity is compromised. Sports is an important aspect of education and is deeply connected with the physical, physiological, mental, and intellectual health of the students. Write an article for your school magazine stressing on the value of sports in education. You are Anil Vij of XII-G.
\includegraphics[width=0.75\linewidth]6.JPG- CBSE CLASS XII - 2025
- Article Writing