Results 1 to 7 of 7

Thread: vlookup

  1. #1
    Star Lounger
    Join Date
    May 2007
    Location
    Cape Town, Western Cape, South Africa
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, im not sure if vlookup will work, im trying to lookup values that are in column f and colunm g in one table. if the value in f appears g and visa versa.

  2. #2
    5 Star Lounger RussB's Avatar
    Join Date
    Dec 2009
    Location
    Grand Rapids, Michigan
    Posts
    803
    Thanks
    10
    Thanked 50 Times in 49 Posts
    That can be done. First be sure that column f and g are the sort order for their table respectively then do a vLookup to 'f' and 'OR' it with the vLookup of 'g'.
    Do you "Believe"? Do you vote? Please Read:
    LEARN something today so you can TEACH something tomorrow.
    DETAIL in your question promotes DETAIL in my answer.
    Dominus Vobiscum <))>(

  3. #3
    Star Lounger
    Join Date
    May 2007
    Location
    Cape Town, Western Cape, South Africa
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, i tried but its giving me N/A, maybe im not doing it right. please see attachment
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post
    Hi, this can easily be done but I don't understand exactly what you are looking for.

    Can you upload the sample again with an example of what you expect it to do.

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Most of the values in G also appear in F and vice versa. The attached shows values that are in Col. G but not in Col. F and it shows values that are in Col. F but not in Col. G

    Some of the values in Col. G appear multiple times in Col. G and Col. F and vice versa. Each value may not appear the same number of times in each of F and G.

    Hope that helps.
    Attached Files Attached Files

  6. #6
    Star Lounger
    Join Date
    May 2007
    Location
    Cape Town, Western Cape, South Africa
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks so much Tim, ure a star, its exactly what i wanted

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    I'm happy that it is what you needed.

Posting Permissions

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