When i type in my VLOOKUP command as below:

=vlookup(B3,'[AMK_CALVIN Appendix.xls]Statewide Info'!$A$3:$M$130,2,false)

Excel just returns the exact text that is typed (including the equals sign,
etc.). In other words, its as though Excel does not see the equals sign.

I dont get and error, or #N/A, or #VALUE, or any other normal thing that
would indicate i have done somehting wrong with my command. Furthermore,
this worked just yesterday. I did exactly the same thing in the same cell,
from the same table_array, and it worked. Now it wont.

any thoughts?

Your cell format may TEXT. Right-click cell, format cells. Set to General.
Once done, with cell selected, press F2 and Enter.

HTH,
Paul

"HydroScience" wrote in message
...
When i type in my VLOOKUP command as below:

=vlookup(B3,'[AMK_CALVIN Appendix.xls]Statewide Info'!$A$3:$M$130,2,false)

Excel just returns the exact text that is typed (including the equals
sign,
etc.). In other words, its as though Excel does not see the equals sign.

I dont get and error, or #N/A, or #VALUE, or any other normal thing that
would indicate i have done somehting wrong with my command. Furthermore,
this worked just yesterday. I did exactly the same thing in the same
cell,
from the same table_array, and it worked. Now it wont.

any thoughts?

Check that cell with formula is not formatted as text: if so, change to
General and hit Enter.

"HydroScience" wrote:

When i type in my VLOOKUP command as below:

=vlookup(B3,'[AMK_CALVIN Appendix.xls]Statewide Info'!$A$3:$M$130,2,false)

Excel just returns the exact text that is typed (including the equals sign,
etc.). In other words, its as though Excel does not see the equals sign.

I dont get and error, or #N/A, or #VALUE, or any other normal thing that
would indicate i have done somehting wrong with my command. Furthermore,
this worked just yesterday. I did exactly the same thing in the same cell,
from the same table_array, and it worked. Now it wont.

any thoughts?

YUP THAT'S IT

THANKS!!

"PCLIVE" wrote:

Your cell format may TEXT. Right-click cell, format cells. Set to General.
Once done, with cell selected, press F2 and Enter.

HTH,
Paul

"HydroScience" wrote in message
...
When i type in my VLOOKUP command as below:

=vlookup(B3,'[AMK_CALVIN Appendix.xls]Statewide Info'!$A$3:$M$130,2,false)

Excel just returns the exact text that is typed (including the equals
sign,
etc.). In other words, its as though Excel does not see the equals sign.

I dont get and error, or #N/A, or #VALUE, or any other normal thing that
would indicate i have done somehting wrong with my command. Furthermore,
this worked just yesterday. I did exactly the same thing in the same
cell,
from the same table_array, and it worked. Now it wont.

any thoughts?