+ Reply to Thread
Results 1 to 4 of 4

How : Interactive Search for multiple rows and columns

  1. #1
    Registered User
    Join Date
    11-07-2021
    Location
    pakistan
    MS-Off Ver
    2022
    Posts
    7

    How : Interactive Search for multiple rows and columns

    Hi,

    I need help to make a search option, which will give me back the search results from another sheet with multiple search values

    Example : I input Two teams thorugh a VBA code(already done). These two teams has the value A1 = Home/Visitor, A3 = TeamName and A5="W" so on......

    Capture.JPG

    So I tap submit and the it gets transfer in the database of another sheet

    Here :

    Capture.JPG

    My Query :

    Can i build a search option. Where I input 3 most important value which is "G""R""W""B""Y" (Short for green, red colour etc..)

    And the search result will give me back the results based on 100% match, 90% match ,80% matc so on. For both Home and Visitor through the database.

    Example : In the databse
    A3=G,B3=G,C3=R

    And search input is "G","G","G"

    The search results should also pull up "G""G""R" cause two of the conditons met . First two values are "G""G"
    If the condition is true for "Home Team". It should also pull up for the value for visitor. As both teams played matches that day
    Last edited by avarics; 04-02-2022 at 11:16 AM. Reason: Uploading sample file

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,585

    Re: How : Interactive Search for multiple rows and columns

    There are instructions at the top of the page on how to post a sample sheet.Thanks

  3. #3
    Registered User
    Join Date
    11-07-2021
    Location
    pakistan
    MS-Off Ver
    2022
    Posts
    7

    Re: How : Interactive Search for multiple rows and columns

    Sample File attached

  4. #4
    Registered User
    Join Date
    11-07-2021
    Location
    pakistan
    MS-Off Ver
    2022
    Posts
    7

    Re: How : Interactive Search for multiple rows and columns

    No help ???

+ 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 multiple columns from Multiple Worksheets and copy rows into a Summary Worksheet
    By kljohn01 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-07-2017, 03:46 PM
  2. Search Multiple Columns and Rows - Show results in Multiple columns and rows
    By heykeighley in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-12-2015, 10:16 AM
  3. [SOLVED] VBA code to search multiple columns and delete any duplicate cells (not rows)
    By philmurp in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-16-2014, 03:27 PM
  4. Replies: 3
    Last Post: 01-21-2014, 05:15 PM
  5. search multiple columns and count number of rows the keywords appear
    By vincegc8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2013, 02:01 PM
  6. Search Multiple Columns and Rows and Return Row
    By rplute in forum Excel General
    Replies: 4
    Last Post: 02-21-2011, 10:58 PM
  7. [SOLVED] Macro to search across multiple columns and delete rows not containing specific value
    By JenIT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2006, 02:05 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