Results 1 to 12 of 12

Search and return multiple results.

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2023
    Location
    Rotterdam, Nederland
    MS-Off Ver
    Office 365
    Posts
    53

    Search and return multiple results.

    Can someone help me find the right formula?

    I would like to find a value in another tab and return different results.

    It concerns the following:

    In the 'Tab' tab, the search value is in column A. I would like to see all matching values from column A ('Search' tab) in column B ('Tab' tab), by searching the matrix B2:O11.

    For example, if I search for the value "5.1", I expect the result in cell B3 (tab 'Tab').
    Code of Conduct
    Policy - Compliance
    Guideline - Risk Strategy
    Guideline - Risk Management
    Guideline - Information Protection
    Guideline - Data Privacy Protection
    Guideline - Identity and Access Management

    Next comes cell B4 the result.
    ""


    The result will then appear in cell B5.
    Guideline - Identity and Access Management

    Scherm?afbeelding 2023-03-31 om 22.43.34.pngScherm?afbeelding 2023-03-31 om 22.43.30.png


    What I have already found or tried
    X.LOOKUP = returns only 1 result (the first or the last)
    Pivot table = this is manual work
    Attached Files Attached Files
    Last edited by Mxmaarten; 04-01-2023 at 07:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup & return multiple search results
    By Doja in forum Excel General
    Replies: 3
    Last Post: 11-27-2020, 10:12 AM
  2. Userform Search when search two text boxes return multiple results
    By nekiwa07 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2020, 09:42 AM
  3. [SOLVED] Search multiple criteria and return multiple results with Closest value
    By palash1010 in forum Excel General
    Replies: 1
    Last Post: 05-28-2020, 12:23 AM
  4. [SOLVED] Macro- Search multiple criteria in spreadsheet return with multiple results in new sheet
    By nicebeaches in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2018, 04:47 PM
  5. How to return multiple results in a search
    By jrlafrance in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-22-2017, 09:25 PM
  6. Replies: 6
    Last Post: 08-22-2014, 08:47 AM
  7. User Form to Search multiple Criteria to return multiple Results
    By Calieth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-16-2011, 11:57 AM

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