Page 1 of 2 12 LastLast
Results 1 to 10 of 14

VLOOKUP displays the formula instead of the result

This is a discussion on VLOOKUP displays the formula instead of the result within the Excel Questions forums, part of the Question Forums category; My VLOOKUP formula is displaying in the cell instead of the result. The formula is VLOOKUP(A1, income_codes, 2, FALSE) and ...

  1. #1
    New Member
    Join Date
    May 2003
    Posts
    20

    Default VLOOKUP displays the formula instead of the result

    My VLOOKUP formula is displaying in the cell instead of the result. The formula is VLOOKUP(A1, income_codes, 2, FALSE) and in the formula editor the result (00017) is calculated correctly.
    However the cell displays =VLOOKUP(A1, income_codes, 2, FALSE) instead of the answer 00017.
    My view options are not set to display formulas. The codes are formatted as text in the range income_codes as they start with zeros.

    Any ideas?


  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,450

    Default

    press Alt + ` (tilde key, left of 1). does that help?
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,151

    Default Re: VLOOKUP displays the formula instead of the result

    Click in the cell and go to Edit/Replace and replace = with =.

  4. #4
    New Member
    Join Date
    May 2003
    Posts
    20

    Default Re: VLOOKUP displays the formula instead of the result

    neither of those things made a difference I'm afraid

    if I try replacing the = with =. it says my formulas has an error.

  5. #5
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,450

    Default

    can you post your formula?
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,151

    Default Re: VLOOKUP displays the formula instead of the result

    Quote Originally Posted by shelley
    neither of those things made a difference I'm afraid

    if I try replacing the = with =. it says my formulas has an error.
    Leave out the period.....

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: VLOOKUP displays the formula instead of the result

    Hi Shelley:

    If you are having difficulty with replacing = with =

    let us try this. Select the cell, replace the = sign with #, and then
    select the same cell again and replace # with =

    Does it work for you?
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  8. #8
    New Member
    Join Date
    May 2003
    Posts
    20

    Default Re: VLOOKUP displays the formula instead of the result

    oops I'm with you now ....

    it sort of works - the replace shows the result correctly until you click in the formula cell again and then the formula comes back.

    I'll see what the user thinks.

  9. #9
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,151

    Default Re: VLOOKUP displays the formula instead of the result

    Quote Originally Posted by shelley
    oops I'm with you now ....

    it sort of works - the replace shows the result correctly until you click in the formula cell again and then the formula comes back.

    I'll see what the user thinks.
    You'll need to reformat that cell back to General. It's formatted as text. I'm guessing that the Vlookup returns a text value and thus Excel formats it as text. Then the next time you go in a enter a formula, Excel thinks it's still a text value.

  10. #10
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761

    Default Re: VLOOKUP displays the formula instead of the result

    Quote Originally Posted by shelley
    ... until you click in the formula cell again and then the formula comes back.

    I'll see what the user thinks.
    You sure didn't double click in the formula cell, and therefore invoked edit mode? Is there a flashing | in the cell? Click or arrow out side the cell, and what happens?

    Richard
    If absence makes the heart grow fonder and familiarity breeds contempt, perhaps my wife should live in Darwin?

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com