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 & H & 15000 & 30000 & 45000
2 & I & 18000 & 32000 & 50000
3 & J & 20000 & 29000 & 49000
4 & K & 23000 & 26000 & 49000
5 & L & 20000 & 30000 & 50000
6 & M & 24000 & 28000 & 52000
7 & N & 24000 & 28000 & 52000
\end{array}
\]
% Question details
(i) = VLOOKUP (B1, B2 : E8, 2, 0)
(ii) = SQRT (VLOOKUP (B5, B8 : E8, 2, 0) – 10000)
(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