Look at the cell format, should not be text, if so change to general or
number then press F2 and enter

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Phil" <Phil@discussions.microsoft.com> wrote in message
news:5408464E-A83F-4C88-B343-01378C0F6963@microsoft.com...
> Hello,
>
> For some unknown reason (to me at least), when I try to use the VLOOKUP
> function now (on the same spreadsheet that I've been using for months), it
> only shows the formula, and not the value that I'm trying to obtain.
> However, when constructing the VLOOKUP function, when I fill in the
> Lookup_Value, Table_Array, Col_index_num, and Range_Lookup fields, each
> time
> I step through the fields, the values on the right of each respective
> field
> ARE correctly shown. And down in the left corner, where it says "Formula
> Result", that value is correct. But when I hit "OK", the only thing that
> shows is the formula. Also, when I go the cell with the VLOOKUP function
> in
> it, and right-click, and look in the "Sample" window, the value IS ALSO
> correctly shown.
>
> Cells that are using the VLOOKUP are formatted to General format.
>
> Somehow, somewhere, I have changed a setting or something.
>
> Why won't this work?
>
> Thanks in advance for your replies.
>
> Phil.
> BTW, when I try it on a brand new file, it works fine.