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	Total half yearly sales
$\displaystyle 2$	$\displaystyle 1$	A	$\displaystyle 10000$	$\displaystyle 15000$	$\displaystyle 25000$
$\displaystyle 3$	$\displaystyle 2$	B	$\displaystyle 40000$	$\displaystyle 35000$	$\displaystyle 75000$
$\displaystyle 4$	$\displaystyle 3$	C	$\displaystyle 25000$	$\displaystyle 40000$	$\displaystyle 65000$
$\displaystyle 5$	$\displaystyle 4$	D	$\displaystyle 30000$	$\displaystyle 50000$	$\displaystyle 80000$
$\displaystyle 6$	$\displaystyle 5$	E	$\displaystyle 34000$	$\displaystyle 45000$	$\displaystyle 79000$
$\displaystyle 7$	$\displaystyle 6$	F	$\displaystyle 12000$	$\displaystyle 30000$	$\displaystyle 42000$
$\displaystyle 8$	$\displaystyle 7$	G	$\displaystyle 38000$	$\displaystyle 56000$	$\displaystyle 94000$

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$