VLOOKUP PROBLEM

G

Gilbert

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.
 
M

MarkN

Gilbert,

Have you tried going Tools, Options and then select the View tab. Make sure
that the tick is not in the Formulas box.
 
M

MarkN

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?
 
R

Ragdyer

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.
 
G

Gilbert

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.
 
Top