Vlookup Results

  • Hello,

    I need help on the Vlookup function,
    I wan to create a table using 2 column of data.Below are the data

    Type Name
    A Danon
    B Chris
    C Hilton
    A Jin
    A King
    B Ling
    C Seng
    D Aaron
    B Halim

    I wan to convert these data to a table which have four dimension. A, B, C, D.
    With Vlookup function, i can do it. But, i find difficulty when the result is overlap, when in the type A, got Danon, Jin, and King. My result only can lookup is King. Other cannot display.

    Anyone can give me a helping hand on this problem??

    Thanks a lot.

  • Re: Vlookup Results




    Hi!


    I had the same problem a few months ago and if I understand you correctly there is no really simple way to do it, at least not that I know of... What I did to solve it was that I gave every entry a unique number that you can use. Lets say that you have two D Anderson, if you give them different numbers in another column they will still be unique. I dont know you will use the data for but that helped my case anyway....


    Peace!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!