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$	H	$\displaystyle 15000$	$\displaystyle 30000$	$\displaystyle 45000$
$\displaystyle 3$	$\displaystyle 2$	I	$\displaystyle 38000$	$\displaystyle 40000$	$\displaystyle 78000$
$\displaystyle 4$	$\displaystyle 3$	J	$\displaystyle 23000$	$\displaystyle 28000$	$\displaystyle 51000$
$\displaystyle 5$	$\displaystyle 4$	K	$\displaystyle 32000$	$\displaystyle 49000$	$\displaystyle 81000$
$\displaystyle 6$	$\displaystyle 5$	L	$\displaystyle 26000$	$\displaystyle 36000$	$\displaystyle 62000$
$\displaystyle 7$	$\displaystyle 6$	M	$\displaystyle 20000$	$\displaystyle 32000$	$\displaystyle 52000$
$\displaystyle 8$	$\displaystyle 7$	O	$\displaystyle 24000$	$\displaystyle 40000$	$\displaystyle 64000$

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$