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$	Muskmelon	$\displaystyle 45$	$\displaystyle 122$
$\displaystyle 3$	$\displaystyle 2$	Watermelon	$\displaystyle 9$	$\displaystyle 21$
$\displaystyle 4$	$\displaystyle 3$	Squash	$\displaystyle 22$	$\displaystyle 35$
$\displaystyle 5$	$\displaystyle 4$	Gourd	$\displaystyle 47$	$\displaystyle 88$
$\displaystyle 6$	$\displaystyle 5$	Curd	$\displaystyle 49$	$\displaystyle 66$
$\displaystyle 7$	$\displaystyle 6$	Brisket	$\displaystyle 33$	$\displaystyle 43$
$\displaystyle 8$	$\displaystyle 7$	Poultry	$\displaystyle 88$	$\displaystyle 96$

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$