Using the worksheet, find out the error and its reason for the given 'VLOOKUP' syntax:
\[
\begin{array}{|c|c|c|c|}
\hline
\text{S. No.} & \text{Consumables} & \text{Price in FY 21-22} & \text{Price in FY 23-24} \\
\hline
1 & \text{Muskmelon} & 45 & 122 \\
2 & \text{Watermelon} & 9 & 21 \\
3 & \text{Squash} & 22 & 35 \\
4 & \text{Gourd} & 47 & 68 \\
5 & \text{Curd} & 49 & 66 \\
6 & \text{Brisket} & 33 & 43 \\
7 & \text{Poultry} & 88 & 96 \\
\hline
\end{array}
\]
(i) =VLOOKUP(B1, B4 : D6, 2, 0)
(ii) =SQRT(VLOOKUP(C2, C2 : D8, 2, 0) – 100)
(iii) =VLOOKUP(B5, B6 : D8, 1, 0)
(iv) =VLOOKUP(B3, B2 : D8, 5, 0)
(v) =VLOOKUP(B5, B3 : D8, 0, 0)
(vi) =VLOOKUP(B2, B2 : D7, 2, 0)/0
Using the worksheet, find out the error and its reason for the given 'VLOOKUP' syntax:
\[ \begin{array}{|c|c|c|c|} \hline \text{S. No.} & \text{Consumables} & \text{Price in FY 21-22} & \text{Price in FY 23-24} \\ \hline 1 & \text{Muskmelon} & 45 & 122 \\ 2 & \text{Watermelon} & 9 & 21 \\ 3 & \text{Squash} & 22 & 35 \\ 4 & \text{Gourd} & 47 & 68 \\ 5 & \text{Curd} & 49 & 66 \\ 6 & \text{Brisket} & 33 & 43 \\ 7 & \text{Poultry} & 88 & 96 \\ \hline \end{array} \]
(i) =VLOOKUP(B1, B4 : D6, 2, 0)
(ii) =SQRT(VLOOKUP(C2, C2 : D8, 2, 0) – 100)
(iii) =VLOOKUP(B5, B6 : D8, 1, 0)
(iv) =VLOOKUP(B3, B2 : D8, 5, 0)
(v) =VLOOKUP(B5, B3 : D8, 0, 0)
(vi) =VLOOKUP(B2, B2 : D7, 2, 0)/0
Show Hint
Solution and Explanation
\[ \begin{array}{|c|c|c|} \hline \textbf{VLOOKUP Syntax} & \textbf{Error} & \textbf{Reason} \\ \hline \text{(i) =VLOOKUP(B1, B4:D6, 2, 0)} & \#N/A & \text{B1 is not found in the first column of B4:D6.} \\ \hline \text{(ii) =SQRT(VLOOKUP(C2, C2:D8, 2, 0) - 100)} & \#N/A & \text{C2 is not in the first column of C2:D8, causing an invalid result.} \\ \hline \text{(iii) =VLOOKUP(B5, B6:D8, 1, 0)} & \#VALUE! & \text{Column index 1 is invalid for the range B6:D8.} \\ \hline \text{(iv) =VLOOKUP(B3, B2:D8, 5, 0)} & \#REF! & \text{Column index 5 exceeds the columns in B2:D8.} \\ \hline \text{(v) =VLOOKUP(B5, B3:D8, 0, 0)} & \#VALUE! & \text{Column index 0 is invalid (must be at least 1).} \\ \hline \text{(vi) =VLOOKUP(B2, B2:D7, 2, 0)} & \text{No error} & \text{Correct syntax, returns value from the second column.} \\ \hline \end{array} \]
Explanation:
- The lookup value must be in the first column of the range.
- The column index must be within the range of the table array.
- Common errors include \#N/A, \#VALUE!, or \#REF! due to incorrect parameters
Top Questions on Miscellaneous
- Let \[ A=\{z\in\mathbb{C}:|z-2|\le 4\} \quad\text{and}\quad B=\{z\in\mathbb{C}:|z-2|+|z+2|=5\}. \] Then the maximum value of \(|z_1-z_2|\), where \(z_1\in A\) and \(z_2\in B\), is:
- JEE Main - 2026
- Mathematics
- Miscellaneous
- Let \[ f(x)=\int \frac{dx}{2\left(\frac{3}{2}\right)^x+2x\left(\frac12\right)^x} \] such that \(f(0)=-26+24\log_e(2)\). If \(f(1)=a+b\log_e(3)\), where \(a,b\in\mathbb{Z}\), then \(a+b\) is equal to:
- JEE Main - 2026
- Mathematics
- Miscellaneous
- Given below are two statements: Statement I: The function \(f:\mathbb{R}\to\mathbb{R}\) defined by \[ f(x)=\frac{x}{1+|x|} \] is one-one. Statement II: The function \(f:\mathbb{R}\to\mathbb{R}\) defined by \[ f(x)=\frac{x^2+4x-30}{x^2-8x+18} \] is many-one. In the light of the above statements, choose the correct answer.
- JEE Main - 2026
- Mathematics
- Miscellaneous
- Let \([\,\cdot\,]\) denote the greatest integer function. Then \[ \int_{-\pi/2}^{\pi/2} \frac{12(3+[x])}{3+[\sin x]+[\cos x]}\,dx \] is equal to:
- JEE Main - 2026
- Mathematics
- Miscellaneous
- The sum of all the elements in the range of
\[ f(x)=\operatorname{sgn}(\sin x)+\operatorname{sgn}(\cos x) +\operatorname{sgn}(\tan x)+\operatorname{sgn}(\cot x), \]
where
\[ x\neq \frac{n\pi}{2},\ n\in\mathbb{Z}, \]
and
\[ \operatorname{sgn}(t)= \begin{cases} 1, & t>0 \\ -1, & t<0 \end{cases} \]
is:
- JEE Main - 2026
- Mathematics
- Miscellaneous
Questions Asked in CBSE CLASS XII exam
- Find the general solution of the differential equation \[ y\log y\,\frac{dx}{dy}+x=\frac{2}{y}. \]
- CBSE CLASS XII - 2026
- Differential Equations
- A square loop of side 0.50 m is placed in a uniform magnetic field of 0.4 T perpendicular to the plane of the loop. The loop is rotated through an angle of 60° in 0.2 s. The value of emf induced in the loop will be:
- CBSE CLASS XII - 2026
- Electromagnetic induction
A racing track is built around an elliptical ground whose equation is given by \[ 9x^2 + 16y^2 = 144 \] The width of the track is \(3\) m as shown. Based on the given information answer the following:
(i) Express \(y\) as a function of \(x\) from the given equation of ellipse.
(ii) Integrate the function obtained in (i) with respect to \(x\).
(iii)(a) Find the area of the region enclosed within the elliptical ground excluding the track using integration.
OR
(iii)(b) Write the coordinates of the points \(P\) and \(Q\) where the outer edge of the track cuts \(x\)-axis and \(y\)-axis in first quadrant and find the area of triangle formed by points \(P,O,Q\).
- CBSE CLASS XII - 2026
- Integration
- Consider a cylindrical conductor of length \( l \) and area of cross-section \( A \). Current \( I \) is maintained in the conductor and electrons drift with velocity \( \vec{v}_d \, (|\vec{v}_d| = \frac{eE}{m} \tau) \), where symbols have their usual meanings. Show that the conductivity of the material of the conductor is given by \[ \sigma = \frac{n e^2 \tau}{m}. \]
- CBSE CLASS XII - 2026
- Current Density
- The painting Hazrat Nizamuddin Auliya and Amir Khusro belongs to which sub-school of Deccan Miniature?
- CBSE CLASS XII - 2026
- Indian Miniature Paintings and Museums