Strange vLookUp behavior

  • Thread starter Thread starter Rich
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUPS 4
Formula text to columns 7
VLOOKUP problem 3
Excel Vlookup Help 0
how do i use the text in a cell as a named range in a vlookup form 2
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
VLookup 6
Can vlookup work using formula values? 5

Back
Top