Using the worksheet below, find out the error and its reason for the given ‘VLOOKUP’ syntax:
% Table for worksheet
\[
\begin{array}{|c|c|c|c|c|}
S. No. & Product & Q1 Sales (\( \text{\rupee} \)) & Q2 Sales (\( \text{\rupee} \)) & Total Half Yearly Sales (\( \text{\rupee} \))
1 & A & 10000 & 15000 & 25000
2 & B & 40000 & 35000 & 75000
3 & C & 25000 & 30000 & 55000
4 & D & 30000 & 50000 & 80000
5 & E & 45000 & 34000 & 79000
6 & F & 12000 & 30000 & 42000
7 & G & 38000 & 56000 & 94000
\end{array}
\]
% VLOOKUP Syntax
(i) = VLOOKUP(B1, B2 : E8, 2, 0)
(ii) = SQRT(VLOOKUP(B5, B8 : E8, 2, 0) - 100000)
(iii) = VLOOKUP(A2, A2 : A8, 2, 0)
(iv) = VLOOKUP(B2, B3 : E4, 5, 0)
(v) = VLOOKUP(B2, A2 : E8, 0, 0)
(vi) = VLOOKUP(B2, B2 : E8, 2, 0)/0