Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…

	A	B	C	D	E
$\displaystyle 1$	S. No	Product	Q1 sales	Q2 Sales	half yearly sales
$\displaystyle 2$	$\displaystyle 1$	N	$\displaystyle 21000$	$\displaystyle 30000$	$\displaystyle 51000$
$\displaystyle 3$	$\displaystyle 2$	P	$\displaystyle 31000$	$\displaystyle 40000$	$\displaystyle 71000$
$\displaystyle 4$	$\displaystyle 3$	Q	$\displaystyle 4500$	$\displaystyle 28000$	$\displaystyle 32500$
$\displaystyle 5$	$\displaystyle 4$	R	$\displaystyle 6700$	$\displaystyle 49000$	$\displaystyle 55700$
$\displaystyle 6$	$\displaystyle 5$	S	$\displaystyle 55600$	$\displaystyle 36000$	$\displaystyle 91600$
$\displaystyle 7$	$\displaystyle 6$	T	$\displaystyle 32000$	$\displaystyle 32000$	$\displaystyle 64000$
$\displaystyle 8$	$\displaystyle 7$	U	$\displaystyle 11000$	$\displaystyle 40000$	$\displaystyle 51000$

Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2 : E8, $\displaystyle 2$, $\displaystyle 0$) (ii) = SQRT (VLOOKUP (B5, B8 : E8, $\displaystyle 2$, $\displaystyle 0$) - $\displaystyle 100000$) (iii) = VLOOKUP (A2, A2 : A8, $\displaystyle 2$, $\displaystyle 0$) (iv) = VLOOKUP (B2, B3, E4, $\displaystyle 5$, $\displaystyle 0$) (v) = VLOOKUP (B2, A2 : E8, $\displaystyle 0$, $\displaystyle 0$) (vi) = VLOOKUP (B2, B2, E8, $\displaystyle 2$, $\displaystyle 0$)/$\displaystyle 0$