| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP JUST RETURNS THE TEXT OF THE COMMAND
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup returns a zero? | Excel Discussion (Misc queries) | |||
| VLOOKUP Returns #REF | Excel Worksheet Functions | |||
| VLookup returns #VALUE! | Excel Worksheet Functions | |||
| vlookup returns 0.00 | Links and Linking in Excel | |||
| vlookup returns n/a | Excel Worksheet Functions | |||
Hybrid Mode
