Thanks Thanks:  0
Likes Likes:  0
Page 4 of 4 FirstFirst ... 234
Results 31 to 33 of 33

Thread: URGENTTTTTTTTT!!!! I REALLY NEED HELP - VLOOKUP

  1. #31
    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

    there ya go.... well done Sami !


    (not sure I can help much on the others, they're not really stuff I deal with enough to be able to advise on)

  2. #32
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Check your e-mail

    I never received your files. But, I sent you my sample based on your post

  3. #33
    Board Regular
    Join Date
    Mar 2002
    Location
    So Cal
    Posts
    379
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i have had the same problem. if you are doing a vlookup in the same workbook you will need to create abolute references..

    ex.

    vlookup(cell,$cell$:$cell$,1,false)

    or you could try a values(trim()) formula on each column of data. i have found when i do this to each column (on both sources) the vlookup works.

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
  •