+ Reply to Thread
Results 1 to 4 of 4

Search for specific match and calls the entire row from multiple sheets

  1. #1
    Registered User
    Join Date
    05-23-2014
    Posts
    12

    Search for specific match and calls the entire row from multiple sheets

    Hello,

    I'm trying to search for a certain cell text, and bring the entire row containing that text from multiple sheets.
    In each sheet, there are duplicate text values, so I need to bring all of them.

    I made an example file where aa (in yellow highlight is what I'm looking for) is entered and the green highlight part is generated from sheet a and b.
    I been looking at some example with vlookup and index, but I can't seem to find one that combines the duplicated value in the same sheet + multiple sheets.

    Is there a certain thing I should be looking in to?
    any reference or help is appreciated

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,607

    Re: Search for specific match and calls the entire row from multiple sheets

    See attached file - let me know if you need an explanation of how it works.

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Search for specific match and calls the entire row from multiple sheets

    Alternatively, here is a macro enabled spreadsheet which will also do the job.

    example.xlsm

    EDIT: Slight Improvement (Clears previous search)

    example.xlsm
    Last edited by ARowbot; 03-30-2015 at 06:06 PM.

  4. #4
    Registered User
    Join Date
    05-23-2014
    Posts
    12

    Re: Search for specific match and calls the entire row from multiple sheets

    Thank you very much!!
    I will check these out!!

+ 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] Search Columns from Multiple Sheets If Match Populate Value from 1 of the sheets
    By kellyjo7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2014, 05:52 PM
  2. Replies: 4
    Last Post: 10-28-2013, 10:57 AM
  3. [SOLVED] I need to search for a word on multiple sheets and copy the entire row to a new sheet
    By jkm750 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 12:13 AM
  4. [SOLVED] How do you search through multiple sheets to find a specific value?
    By bean29 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 10:07 AM
  5. How to use index match to search for a value from multiple sheets
    By yoyogu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2012, 02:16 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