Results 1 to 2 of 2

Thread: How to pull data by typing in one specific value

  1. #1

    How to pull data by typing in one specific value



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

    i am creating a routine for my workers. I have two rows of data, one has the day of the rolling week (for example Week1Mon) and the other row has the task. I want to create on a new tab a formula where they can just type in Week1Mon and all the tasks come up next to it. I tried VLOOKUP, but it only gives me one value, not all of them?

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Quote Originally Posted by allblacks86 View Post
    i am creating a routine for my workers. I have two rows of data, one has the day of the rolling week (for example Week1Mon) and the other row has the task. I want to create on a new tab a formula where they can just type in Week1Mon and all the tasks come up next to it. I tried VLOOKUP, but it only gives me one value, not all of them?
    Can U forward Excel file i.e, sample data

Posting Permissions

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