+ Reply to Thread
Results 1 to 5 of 5

Simple But Stumped

  1. #1
    Brian Keanie
    Guest

    Simple But Stumped

    Maybe it should be "Simple AND Stumped"

    Attempting a very simple VLOOKUP formula and can't get the result in the
    cell with the formula. =VLOOKUP(B4,testrange,2,FALSE).
    The Fx or Function Arguments wizard shows me the correct answer but it does
    not appear in the cell. Only the formula appears there.

    I have used VLOOKUPS successfully before, but stumped here. Any hints or
    solutions would be appreciated.

    Regards



  2. #2
    Bob Phillips
    Guest

    Re: Simple But Stumped

    Is the cell formatted as text?

    Also, check Tools>Options>View that the Formulas box is not checked.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Brian Keanie" <[email protected]> wrote in message
    news:[email protected]...
    > Maybe it should be "Simple AND Stumped"
    >
    > Attempting a very simple VLOOKUP formula and can't get the result in the
    > cell with the formula. =VLOOKUP(B4,testrange,2,FALSE).
    > The Fx or Function Arguments wizard shows me the correct answer but it

    does
    > not appear in the cell. Only the formula appears there.
    >
    > I have used VLOOKUPS successfully before, but stumped here. Any hints or
    > solutions would be appreciated.
    >
    > Regards
    >
    >




  3. #3
    Brian Keanie
    Guest

    Re: Simple But Stumped

    Thanx Bob .... The cell is formatted as text and the T>O>V>Formulas is not
    checked. The thing I can't quite get is that the wee wizard comes up with
    the correct answer but it will not show in the cell.

    "Bob Phillips" <[email protected]> wrote in message
    news:%[email protected]...
    > Is the cell formatted as text?
    >
    > Also, check Tools>Options>View that the Formulas box is not checked.
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Brian Keanie" <[email protected]> wrote in message
    > news:[email protected]...
    > > Maybe it should be "Simple AND Stumped"
    > >
    > > Attempting a very simple VLOOKUP formula and can't get the result in the
    > > cell with the formula. =VLOOKUP(B4,testrange,2,FALSE).
    > > The Fx or Function Arguments wizard shows me the correct answer but it

    > does
    > > not appear in the cell. Only the formula appears there.
    > >
    > > I have used VLOOKUPS successfully before, but stumped here. Any hints or
    > > solutions would be appreciated.
    > >
    > > Regards
    > >
    > >

    >
    >




  4. #4
    Peo Sjoblom
    Guest

    Re: Simple But Stumped

    Don't format the cell as text, format as general

    --
    Regards,

    Peo Sjoblom

    (No private emails please, for everyone's
    benefit keep the discussion in the newsgroup/forum)



    "Brian Keanie" <[email protected]> wrote in message
    news:[email protected]...
    > Thanx Bob .... The cell is formatted as text and the T>O>V>Formulas is not
    > checked. The thing I can't quite get is that the wee wizard comes up with
    > the correct answer but it will not show in the cell.
    >
    > "Bob Phillips" <[email protected]> wrote in message
    > news:%[email protected]...
    >> Is the cell formatted as text?
    >>
    >> Also, check Tools>Options>View that the Formulas box is not checked.
    >>
    >> --
    >>
    >> HTH
    >>
    >> RP
    >> (remove nothere from the email address if mailing direct)
    >>
    >>
    >> "Brian Keanie" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Maybe it should be "Simple AND Stumped"
    >> >
    >> > Attempting a very simple VLOOKUP formula and can't get the result in
    >> > the
    >> > cell with the formula. =VLOOKUP(B4,testrange,2,FALSE).
    >> > The Fx or Function Arguments wizard shows me the correct answer but it

    >> does
    >> > not appear in the cell. Only the formula appears there.
    >> >
    >> > I have used VLOOKUPS successfully before, but stumped here. Any hints
    >> > or
    >> > solutions would be appreciated.
    >> >
    >> > Regards
    >> >
    >> >

    >>
    >>

    >
    >




  5. #5
    Forum Contributor
    Join Date
    01-18-2005
    Location
    Auckland New Zealand
    MS-Off Ver
    Office Professional 2007
    Posts
    295
    You may need to delete the column first (copy one cell of the range somewhere else to hold on to the formula), and then insert a new one, format as general, then copy the formula back in, and paste special (formula), then copy it to all the cells in the range.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1