+ Reply to Thread
Results 1 to 9 of 9

Embedded filter – multiple results list

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    59

    Question Embedded filter – multiple results list

    Hi all!

    I’m trying to figure out how to apply some kind of embedded filter in excel. In a very basic explanation, I’m searching for something like the standard filter function but without pressing the filter button all the time…
    In one tab I have a table with all the information for some machine parts: the compatible machine for a part; the part ID; the part name; the amount of components of that part. The thing is that for the same machine I can have multiple line results (a specific part is compatible with more than one machine) and due to this – as far as my knowledge goes - I’m not able to use a VLOOKUP.
    I have a second tab where I want to have a “search box” where I can type the part ID and bellow that several result lines (with all the columns in the original table).

    For example, when searching for the 920 machine, the result should give me 4 lines:
    Attachment 367667

    This is the file:
    Attachment 367668

    Can someone please help me?

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Embedded filter – multiple results list

    This can be done, however both your attachments seem to be invalid. Can you try uploading them again? Click on Go Advanced below --> Manage Attachments to upload a sample document.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    59

    Re: Embedded filter – multiple results list

    Hi,


    I'm sorry.
    Here they are: Partsfile.xlsxPicture.JPG

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Embedded filter – multiple results list

    When you say you want to be able to search by machine model, does that correspond to Compatible Machine in your first sheet?

  5. #5
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    59

    Re: Embedded filter – multiple results list

    Hi mcmahobt,

    Yes.

  6. #6
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Embedded filter – multiple results list

    Will something like the attached workbook do?

    Hope this helps!
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    59

    Re: Embedded filter – multiple results list

    Yes! That's it! Everything is working fine except if I search for the last machine (99x). I even tried to change it in the parts table sheet, believing it was related to the letter "x", but still no result is found

  8. #8
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Embedded filter – multiple results list

    My mistake, the range was a little off in one of the references. Check the attached, 99x now shows up.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    59

    Re: Embedded filter – multiple results list

    mcmahobt, you're great! It's working like a charm!
    Many thanks!

+ 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. Need help to Filter results from a colounm which has a certain list choosen
    By buckles23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2014, 10:22 AM
  2. Replies: 3
    Last Post: 10-30-2013, 09:18 AM
  3. Filter List Results Dependent on another Filter List
    By Owlsfan in forum Excel General
    Replies: 2
    Last Post: 04-28-2013, 06:20 PM
  4. Automatically filter? to list multiple results
    By matt2 in forum Excel General
    Replies: 4
    Last Post: 03-29-2010, 01:11 PM
  5. Replies: 2
    Last Post: 08-18-2006, 05:28 AM

Tags for this Thread

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