Question

From the given ‘VLOOKUP’ syntax, find out the error and its reason using the worksheet: 

(i) = VLOOKUP(B5, C3:F10, 2, 0) 
(ii) = SQRT(VLOOKUP(B3, B3:F10, 2, 0) - 100) 
(iii) = VLOOKUP(B2, B3:F10, 5, 0) 
(iv) = VLOOKUP(B3, B3:B10, 2, 0) 
(v) = VLOOKUP(B6, B3:F10, 0, 0) 
(vi) = VLOOKUP(B6, B3:F10, 2, 0)/0 
 

Hint:

Ensure the lookup value is in the first column of the table array. Use a valid column index that corresponds to the structure of the table array. Avoid dividing by zero or referencing incorrect ranges in formulas.

Answer 1