+ Reply to Thread
Results 1 to 5 of 5

WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOWORK

  1. #1
    Half Manx
    Guest

    WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOWORK

    I have set a VLOOKUP formula to match account numbers. How ever I have to
    click double click on the cell before the formula recognises the account
    number. I have to do this for each cell. I have tried different formats. It
    is not saving me that much time.

  2. #2
    ScottO
    Guest

    Re: WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOWORK

    It sounds like you have Calculation set to Manual. If you set it to
    Automatic, it should work OK. (Go to Tools/Options/Calculation).
    Rgds,
    ScottO

    "Half Manx" <Half Manx@discussions.microsoft.com> wrote in message
    news:B0BC9C18-0ADA-4BE3-A9D4-B264CD08B25E@microsoft.com...
    | I have set a VLOOKUP formula to match account numbers. How ever I
    have to
    | click double click on the cell before the formula recognises the
    account
    | number. I have to do this for each cell. I have tried different
    formats. It
    | is not saving me that much time.



  3. #3
    Half Manx
    Guest

    Re: WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOW

    The calculation is set to automatic and the cell format is 'number'. I have
    even tried 'F9' calc now, but that doesn't work either. I'm puzzled?

    "ScottO" wrote:

    > It sounds like you have Calculation set to Manual. If you set it to
    > Automatic, it should work OK. (Go to Tools/Options/Calculation).
    > Rgds,
    > ScottO
    >
    > "Half Manx" <Half Manx@discussions.microsoft.com> wrote in message
    > news:B0BC9C18-0ADA-4BE3-A9D4-B264CD08B25E@microsoft.com...
    > | I have set a VLOOKUP formula to match account numbers. How ever I
    > have to
    > | click double click on the cell before the formula recognises the
    > account
    > | number. I have to do this for each cell. I have tried different
    > formats. It
    > | is not saving me that much time.
    >
    >
    >


  4. #4
    Ragdyer
    Guest

    Re: WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOW

    Try this:

    Select a "bad" formula, then:
    <Edit> <Replace>
    In the "Find What" box, enter
    =
    In the "Replace With" box, enter
    =
    Then hit <Replace>.

    Does that work?
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "Half Manx" <HalfManx@discussions.microsoft.com> wrote in message
    news:FEE1675E-4EAB-44D9-B116-599286B760C2@microsoft.com...
    > The calculation is set to automatic and the cell format is 'number'. I

    have
    > even tried 'F9' calc now, but that doesn't work either. I'm puzzled?
    >
    > "ScottO" wrote:
    >
    > > It sounds like you have Calculation set to Manual. If you set it to
    > > Automatic, it should work OK. (Go to Tools/Options/Calculation).
    > > Rgds,
    > > ScottO
    > >
    > > "Half Manx" <Half Manx@discussions.microsoft.com> wrote in message
    > > news:B0BC9C18-0ADA-4BE3-A9D4-B264CD08B25E@microsoft.com...
    > > | I have set a VLOOKUP formula to match account numbers. How ever I
    > > have to
    > > | click double click on the cell before the formula recognises the
    > > account
    > > | number. I have to do this for each cell. I have tried different
    > > formats. It
    > > | is not saving me that much time.
    > >
    > >
    > >



  5. #5
    Half Manx
    Guest

    Re: WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOW

    What a star, it didn't work on the formula but I did it with a number '1'
    (find & replace) and this fixed the error.

    Thanks very much.

    "Ragdyer" wrote:

    > Try this:
    >
    > Select a "bad" formula, then:
    > <Edit> <Replace>
    > In the "Find What" box, enter
    > =
    > In the "Replace With" box, enter
    > =
    > Then hit <Replace>.
    >
    > Does that work?
    > --
    > HTH,
    >
    > RD
    >
    > ---------------------------------------------------------------------------
    > Please keep all correspondence within the NewsGroup, so all may benefit !
    > ---------------------------------------------------------------------------
    >
    > "Half Manx" <HalfManx@discussions.microsoft.com> wrote in message
    > news:FEE1675E-4EAB-44D9-B116-599286B760C2@microsoft.com...
    > > The calculation is set to automatic and the cell format is 'number'. I

    > have
    > > even tried 'F9' calc now, but that doesn't work either. I'm puzzled?
    > >
    > > "ScottO" wrote:
    > >
    > > > It sounds like you have Calculation set to Manual. If you set it to
    > > > Automatic, it should work OK. (Go to Tools/Options/Calculation).
    > > > Rgds,
    > > > ScottO
    > > >
    > > > "Half Manx" <Half Manx@discussions.microsoft.com> wrote in message
    > > > news:B0BC9C18-0ADA-4BE3-A9D4-B264CD08B25E@microsoft.com...
    > > > | I have set a VLOOKUP formula to match account numbers. How ever I
    > > > have to
    > > > | click double click on the cell before the formula recognises the
    > > > account
    > > > | number. I have to do this for each cell. I have tried different
    > > > formats. It
    > > > | is not saving me that much time.
    > > >
    > > >
    > > >

    >
    >


+ 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