+ Reply to Thread
Results 1 to 2 of 2

Looking up value/text in a table by funding the nth row match and nth column match

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    Montreal, Canada
    MS-Off Ver
    2016
    Posts
    87

    Looking up value/text in a table by funding the nth row match and nth column match

    Hello Excel Masters in disguise,

    It has been a while.

    Have a challenge here and trying to figure out a workaround.

    Quite simply, I want to use a formula to look up the nth row match or nth column match using a formula (if it is even possible!)

    Please find attached a sample workbook, which clearly explains my desired result using an example.
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Looking up value/text in a table by funding the nth row match and nth column match

    Try this:

    =INDEX(A:M,AGGREGATE(15,6,ROW(B4:B14)/(B4:B14="Detroit"),3),AGGREGATE(15,6,COLUMN(C3:M3)/(C3:M3="Canada"),2))

    You have 724 highlighted, but that is the 4th instance of Detroit, not the 3rd.
    You didn't specify what to look for in row 3, but I assumed it was Canada.

+ 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: 11
    Last Post: 11-26-2022, 04:58 PM
  2. [SOLVED] Count Unique Values with Partial Match one column exact match another column
    By carsto in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-30-2019, 09:56 AM
  3. Replies: 6
    Last Post: 05-31-2019, 12:39 AM
  4. Matching text in an array with text in a table - Application.Match syntax help?
    By reach78 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2015, 06:03 PM
  5. [SOLVED] Two Excel sheets trying to match text data and return the match from the second column!
    By bankcott in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 02:17 PM
  6. Replies: 4
    Last Post: 12-14-2009, 03:21 PM
  7. [SOLVED] Match row that contains text text string; list associated values from pivot table
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2009, 07:50 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