VLOOKUP just returns formula

[Jan Ogg]

Help, my VLOOKUP is just putting the formula into the cell.
=VLOOKUP(A13,'Tasks'!A210,2,FALSE)
Where A13 is on same worksheet as the lookup cell.
What am I doing wrong?

 

[David Biddulph]

My guess is that you've got the cell formatted as text. Format the cell to
General, then go into edit mode & re-enter the formula.

 

[ozgrid.com]

Use any cell format other than Text. Then re-enter you formulas or
Edit>Replace = with =