VLOOKUP not working anymore

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

Hi Peo,

As I had said in my original post, the cell is ALREADY formatted to GENERAL.
But Thanks for trying to help, anyway. Any other ideas?

"Peo Sjoblom" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

Hi
In TOOLS>OPTIONS>View - Window options
make sure you don't have "Formulas" checked

It's easily done as the keyboard shortcut is CTRL+` which is next to
CTRL+TAB for swiching workbooks or CTRL+1 for format cells!

"Phil" <[email protected]> wrote in message
news:[email protected]...
> 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.

Did you do the second part?
Try to replace the equal sign with the equals sign to force calculation.

If that doesn't work try Ctrl + `

Peo


"Phil" <[email protected]> wrote in message
news:[email protected]...
> Hi Peo,
>
> As I had said in my original post, the cell is ALREADY formatted to
> GENERAL.
> But Thanks for trying to help, anyway. Any other ideas?
>
> "Peo Sjoblom" wrote:
>
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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.
>>
>>
>>

Peo,

The CTRL + ` worked.

Thanks!

"Peo Sjoblom" wrote:

> Did you do the second part?
> Try to replace the equal sign with the equals sign to force calculation.
>
> If that doesn't work try Ctrl + `
>
> Peo
>
>
> "Phil" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Peo,
> >
> > As I had said in my original post, the cell is ALREADY formatted to
> > GENERAL.
> > But Thanks for trying to help, anyway. Any other ideas?
> >
> > "Peo Sjoblom" wrote:
> >
> >> 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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.
> >>
> >>
> >>
>
>
>

Loomah,

You are correct. It is working fine now.

Thanks!

"Loomah" wrote:

> Hi
> In TOOLS>OPTIONS>View - Window options
> make sure you don't have "Formulas" checked
>
> It's easily done as the keyboard shortcut is CTRL+` which is next to
> CTRL+TAB for swiching workbooks or CTRL+1 for format cells!
>
> "Phil" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>