+ Reply to Thread
Results 1 to 4 of 4

Determine a Row/Column then Search it

  1. #1
    Registered User
    Join Date
    05-23-2018
    Location
    Texas, United States
    MS-Off Ver
    2013
    Posts
    32

    Determine a Row/Column then Search it

    I need to set up a formula that will first find the correct row or column in a table, and then search through that specific row/column to see if a value exists in it.

    So in the attached tables, I need to determine what row/column to search through based on the First Condition, and then search that row/column for the second condition, and if the second condition exists in the table, return true
    Attached Files Attached Files
    Last edited by jakegordon97; 01-12-2021 at 12:32 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,267

    Re: Determine a Row/Column then Search it

    In E7 (and copied to E11)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    05-23-2018
    Location
    Texas, United States
    MS-Off Ver
    2013
    Posts
    32

    Re: Determine a Row/Column then Search it

    Yes it does! Thank you so much!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,188

    Re: Determine a Row/Column then Search it

    How about
    for the top table
    =ISNUMBER(MATCH(E6,INDEX(G6:K12,,MATCH(E5,G5:K5,0)),0))

    or for the other table
    =ISNUMBER(MATCH(E10,INDEX(G15:N19,MATCH(E69,G15:G19,0),0),0))

+ 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. Replies: 3
    Last Post: 08-15-2018, 05:09 PM
  2. [SOLVED] Dynamic search; using column # result to determine column used for column/row match.
    By David Brunk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-18-2014, 09:57 PM
  3. [SOLVED] Search Text determine which terms it contains
    By LarryLegend in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2013, 12:12 PM
  4. Replies: 2
    Last Post: 01-31-2013, 07:04 PM
  5. Replies: 1
    Last Post: 07-26-2011, 06:48 AM
  6. Search for data within a Cell to determine result
    By dperry in forum Excel General
    Replies: 2
    Last Post: 05-19-2010, 10:31 PM
  7. Replies: 5
    Last Post: 04-24-2008, 08:20 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