Results 1 to 5 of 5

Thread: looking up a row based on a criteria

  1. #1
    Acolyte happy_smiler1's Avatar
    Join Date
    Aug 2012
    Posts
    67
    Articles
    0
    Excel Version
    office 365

    looking up a row based on a criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I have attached a sample spreadsheet of my test data and what I am looking to do.

    So in my data I have a bunch of locations with names. However as there are multiples of the same location, but different names, when I do a vlookup it returns the same name, but I need it to lookup the location, but return my the names that go to each location, so to check the location, then check the name, if the name and location has been returned in sheet 2, then move onto the next row and check the next row in the data source.

    Any ideas?

    TIA
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,691
    Articles
    0
    Excel Version
    365
    Perhaps people will be more inclined to share their solutions if you shared yours: https://www.excelguru.ca/forums/show...ll=1#post43042

  3. #3
    Acolyte happy_smiler1's Avatar
    Join Date
    Aug 2012
    Posts
    67
    Articles
    0
    Excel Version
    office 365
    I posted the solution to that thread.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,691
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by happy_smiler1 View Post
    I posted the solution to that thread.
    which was: "just doing a macro".

    Sure.

  5. #5
    Acolyte happy_smiler1's Avatar
    Join Date
    Aug 2012
    Posts
    67
    Articles
    0
    Excel Version
    office 365
    Quote Originally Posted by p45cal View Post
    which was: "just doing a macro".

    Sure.
    Just close the post down!

Posting Permissions

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