Strange vLookUp behavior

R

Rich

I am using Excel 97.

The following problem occured to me. I put in a vLookUp like I have
done hundres of times over. Then when I hit enter. Instead of a
vLookUp value being returned. I get the command in the cell like this
:

=vlookup(C2,M17:N21,2,false)

No value is returned. The cell is populated with the above.

What could be wrong.
 
F

Frank Kabel

Hi
check that the cell is not formated as 'Text'. Change this to 'General'
and re-enter your formula.

Also check in 'Tools - Options - View' that 'Formula' is NOT checked
 
Top