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

	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$	Pineapple	$\displaystyle 40$	$\displaystyle 55$
$\displaystyle 3$	$\displaystyle 2$	Kiwi	$\displaystyle 34$	$\displaystyle 45$
$\displaystyle 4$	$\displaystyle 3$	Jackfruit	$\displaystyle 50$	$\displaystyle 62$
$\displaystyle 5$	$\displaystyle 4$	Blueberry	$\displaystyle 35$	$\displaystyle 54$
$\displaystyle 6$	$\displaystyle 5$	Butter	$\displaystyle 50$	$\displaystyle 56$
$\displaystyle 7$	$\displaystyle 6$	Buns	$\displaystyle 48$	$\displaystyle 45$
$\displaystyle 8$	$\displaystyle 7$	Meat	$\displaystyle 36$	$\displaystyle 48$

Using the worksheet, find out the error and its reason for the given 'VLOOKUP' 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$