Results 1 to 4 of 4

Thread: Access 2000

  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2000

    <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15> Newbie poster here - so be gentle..

    But I CAN'T be the only one with this problem... After successfully importing a table from Access I try to use the data in a 'vlookup' function and BLAMMO I get '#N/A' . . . even though the reference is there.

    If I edit the formula of the cell to be located (which, again does contain the searched info) and then hit enter, magically, the vlookup formula works.

    It's not a format problem - I can change the format of the column and the problem remains. the only thing that I can find to fix it is to manually enter the cell over again.

    Lil hep? <img src=/S/help.gif border=0 alt=help width=23 height=15>

    Thanks Much - and maybe I can return the favor one day....

    THX - DIK

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Access 2000

    Hi,
    Is the value you're looking up numeric data? It quite often happens that imported data that looks numeric but is actually treated as text in the original application (policy numbers are a good example) imports as text, whereas in the table where you're looking for the data, it's being treated as a number (if you see what I mean). Vlookup won't match the two even though they look identical.
    Does that sound like your case?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    If the data is supposed to be numeric this little trick might help. Enter the value 1 in a blank cell and copy it. Select all the supposed numbers and then Edit, Paste Special, and select Multiply. I have used that successfully in similar circumstances.


    Andrew C

  4. #4
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    THANK YOU - I knew there had to be a simple solution (read "worlkaround".. hehe

    <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

Posting Permissions

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