+ Reply to Thread
Results 1 to 2 of 2

Help with index, match or lookup

  1. #1
    Forum Contributor
    Join Date
    10-23-2014
    Location
    Kolding, Denmark
    MS-Off Ver
    MS Office 2010
    Posts
    169

    Help with index, match or lookup

    Hi

    I have a file woth a lot of Areas and tasks.
    the Areas are in Row 5 and the tasks are in collum A.
    You only have to du the tasks if there is an X by that task in a certain area.

    I would like to make an easy way to show which task to do in with areas. So you on one sheet can select the area by dropdown and then it will show you a list off all the tasks for that area.

    I hope my problem is understandable
    And that someone can help

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Help with index, match or lookup

    Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "Choose File" (top Left corner).
    Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  2. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  3. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  4. Match/Index/Lookup - Searching From Bottom to Top (A reverse lookup maybe)
    By Neutralizer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 03:55 AM
  5. Replies: 7
    Last Post: 06-19-2011, 12:51 PM
  6. Lookup/Index-Match-Match using segments
    By BRISBANEBOB in forum Excel General
    Replies: 11
    Last Post: 06-10-2009, 03:45 AM
  7. Using Lookup instead of Index/Match for left lookup
    By teylyn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2008, 09:20 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1