| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP PROBLEM
The problem that I'm getting when using the vlookup is that the only answer
that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP PROBLEM
Gilbert,
Have you tried going Tools, Options and then select the View tab. Make sure that the tick is not in the Formulas box. -- Hope this helps, MarkN "Gilbert" wrote: The problem that I'm getting when using the vlookup is that the only answer that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP PROBLEM
Thanks for the response Mark,
Yes I have and it's no checked. "MarkN" wrote: Gilbert, Have you tried going Tools, Options and then select the View tab. Make sure that the tick is not in the Formulas box. -- Hope this helps, MarkN "Gilbert" wrote: The problem that I'm getting when using the vlookup is that the only answer that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP PROBLEM
Have you checked the formatting of the cells? Does a simple sum function on
the same sheet work correctly. Can you paste the function into a response to this? -- Thanks, MarkN "Gilbert" wrote: Thanks for the response Mark, Yes I have and it's no checked. "MarkN" wrote: Gilbert, Have you tried going Tools, Options and then select the View tab. Make sure that the tick is not in the Formulas box. -- Hope this helps, MarkN "Gilbert" wrote: The problem that I'm getting when using the vlookup is that the only answer that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP PROBLEM
Sounds like the cell was formatted as 'text' before the formula was entered.
Click in the cell, then: <Ctrl <Shift < ~ Then <F2 Then <Enter If that works, then it definitely was formatted to text prior to the formula entry. Those keystrokes were simply a shortcut to: Format the cell to 'General', Enter the 'Edit' mode, Register the revision. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gilbert" wrote in message ... Thanks for the response Mark, Yes I have and it's no checked. "MarkN" wrote: Gilbert, Have you tried going Tools, Options and then select the View tab. Make sure that the tick is not in the Formulas box. -- Hope this helps, MarkN "Gilbert" wrote: The problem that I'm getting when using the vlookup is that the only answer that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP PROBLEM
It works now. You're correct about the information was originally transfered
as text but I changed to general and it wasn't working. The only thing that I can think of is that I didn't save it but I didn't think that matter. Thanks for the help. "Ragdyer" wrote: Sounds like the cell was formatted as 'text' before the formula was entered. Click in the cell, then: <Ctrl <Shift < ~ Then <F2 Then <Enter If that works, then it definitely was formatted to text prior to the formula entry. Those keystrokes were simply a shortcut to: Format the cell to 'General', Enter the 'Edit' mode, Register the revision. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gilbert" wrote in message ... Thanks for the response Mark, Yes I have and it's no checked. "MarkN" wrote: Gilbert, Have you tried going Tools, Options and then select the View tab. Make sure that the tick is not in the Formulas box. -- Hope this helps, MarkN "Gilbert" wrote: The problem that I'm getting when using the vlookup is that the only answer that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP PROBLEM
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gilbert" wrote in message ... It works now. You're correct about the information was originally transfered as text but I changed to general and it wasn't working. The only thing that I can think of is that I didn't save it but I didn't think that matter. Thanks for the help. "Ragdyer" wrote: Sounds like the cell was formatted as 'text' before the formula was entered. Click in the cell, then: <Ctrl <Shift < ~ Then <F2 Then <Enter If that works, then it definitely was formatted to text prior to the formula entry. Those keystrokes were simply a shortcut to: Format the cell to 'General', Enter the 'Edit' mode, Register the revision. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gilbert" wrote in message ... Thanks for the response Mark, Yes I have and it's no checked. "MarkN" wrote: Gilbert, Have you tried going Tools, Options and then select the View tab. Make sure that the tick is not in the Formulas box. -- Hope this helps, MarkN "Gilbert" wrote: The problem that I'm getting when using the vlookup is that the only answer that I get is the formula it self. As I am entering the formula in the dialogue box, the dialogue box displays the correct value but when I click OK, it returns the formula instead of the correct value. The format on both columns are the same. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup problem | Excel Discussion (Misc queries) | |||
| Vlookup problem with Date Time | Excel Worksheet Functions | |||
| vlookup Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Problem | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Linear Mode
