For example, the formula below is trying to look up the quantity of ‘Pig’ in the table using the VLOOKUP function. But, in B13, the text string ‘Pig’ is entered without double quotes (““) in the formula. So the formula returns the #NAME? error as shown below. If there are q...