When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so the
looked up value of "S".