Results 1 to 2 of 2

Thread: Conditional string population between sheets

  1. #1
    Junior Member
    Join Date
    Aug 2016
    Posts
    1
    Rep Power
    0

    Conditional string population between sheets

    I am not sure whether this would be at all possible. As the information is sensitive I will try to explain best I can.

    Basically I want to make it so that in sheet1 I have groups based on a certain skill capability so that one can easily see all individuals who are trained on said skill across all the various teams. In Sheet 2 I have the data which is grouped by teams (one row for each individual) This is to make it easier for people to fill out their own skills but for managers to get an overall without having someone going in and manually pulling this information.

    Essentially I want to populate column b in sheet1 with data from column b in sheet2, but only IF the string in column o on the same row matches any of the items in sheet3!A15:A21. The key thing here is that the row in sheet1 wont necessarily be the same as in sheet2..

    Now my issue is, I want to be able to populate all of the appropriate rows to reflect this but I am not sure how or if that would be possible as Vlookup for example would only take me to the first person that had a skill level and that would be it...

    I tried to fiddle with index and match but I got a value error and I just think I am way out of my depth.

    Please help me!

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Are you looking for multiple lookup? If not, I would strongly recommend uploading a sample file which will help come up with a solution
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 3
    Last Post: 07-27-2014, 10:03 PM
  2. string manipulation
    By kylefoley76 in forum Excel Help
    Replies: 5
    Last Post: 02-20-2014, 12:10 AM
  3. Reverse a string by using array method
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 07-09-2013, 09:07 AM
  4. Concatenate array string
    By tushar.tarafdar in forum Excel Help
    Replies: 2
    Last Post: 09-20-2012, 12:00 PM
  5. Remove only numeric value in the end of any string
    By LalitPandey87 in forum Excel Help
    Replies: 3
    Last Post: 04-08-2012, 09:39 AM

Posting Permissions

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