Using the worksheet, find out the error and its reason for the given syntax: (i) = VLOOKUP (B1, B4: D6, 2, 0) (ii) = SQRT (VLOOKUP (C2, C2: D8, 2, 0)…

	A	B	C	D
$\displaystyle 1$	S. No.	Consumables	Price in FY $\displaystyle 21$ – $\displaystyle 22$	Price in FY $\displaystyle 23$ – $\displaystyle 24$
$\displaystyle 2$	$\displaystyle 1$	Apple	$\displaystyle 50$	$\displaystyle 60$
$\displaystyle 3$	$\displaystyle 2$	Orange	$\displaystyle 20$	$\displaystyle 40$
$\displaystyle 4$	$\displaystyle 3$	Banana	$\displaystyle 60$	$\displaystyle 80$
$\displaystyle 5$	$\displaystyle 4$	Lemon	$\displaystyle 40$	$\displaystyle 80$
$\displaystyle 6$	$\displaystyle 5$	Milk	$\displaystyle 53$	$\displaystyle 60$
$\displaystyle 7$	$\displaystyle 6$	Bread	$\displaystyle 40$	$\displaystyle 45$
$\displaystyle 8$	$\displaystyle 7$	Egg	$\displaystyle 58$	$\displaystyle 60$

Using the worksheet, find out the error and its reason for the given syntax : (i) = VLOOKUP (B1, B4 : D6, $\displaystyle 2$, $\displaystyle 0$) (ii) = SQRT (VLOOKUP (C2, C2 : D8, $\displaystyle 2$, $\displaystyle 0$) - $\displaystyle 100$) (iii) = VLOOKUP (B5, B6 : D8, $\displaystyle 1$, $\displaystyle 0$) (iv) = VLOOKUP (B3, B2 : D8, $\displaystyle 5$, $\displaystyle 0$) (v) = VLOOKUP (B5, B3 : D8, $\displaystyle 0$, $\displaystyle 0$) (vi) = VLOOKUP (B2, B2 : D7, $\displaystyle 2$, $\displaystyle 0$) / $\displaystyle 0$