Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: f2 & enter

  1. #1
    Guest

    Default

    I have two sheets of zip codes that i am trying to vlookup off of and even though the two sheets are in the same format, the vlookup doesn't recognize the cells until I "f2" and then hit "enter". only after i hit "f2" and then "enter" am i able to get the desired result. HELP! I have over 16K zip codes that I need to query off of in the vlookup.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-28 12:04, Anonymous wrote:
    I have two sheets of zip codes that i am trying to vlookup off of and even though the two sheets are in the same format, the vlookup doesn't recognize the cells until I "f2" and then hit "enter". only after i hit "f2" and then "enter" am i able to get the desired result. HELP! I have over 16K zip codes that I need to query off of in the vlookup.
    have you got manual calc switched on ?

    try :

    tools
    options
    calculation
    calculation = automatic

  3. #3
    Guest

    Default

    Yep, Calc is on automatic.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    with 15,000 lookup functions, are you sure you're waiting for it to finish calculating ?

    bottom right - if it says "calculating" you need to wait till it's finished...

    JUst guessing here...


  5. #5
    Guest

    Default

    It is definitely calculating. the problem is that excel recognizes some cells as numbers and others as characters even though the formatting is the same.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeah, sorry, I just saw your parallel thread which looks like solving the problem.

    Over and out.

Some videos you may like

User Tag List

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
  •