+ Reply to Thread
Results 1 to 4 of 4

find row header based on table and column headers reverse lookup index & match

  1. #1
    Registered User
    Join Date
    12-03-2019
    Location
    philippines
    MS-Off Ver
    2016
    Posts
    2

    find row header based on table and column headers reverse lookup index & match

    Hello all. I want to ask help as i'm lost in the woods. i want to get the row header (which is column players) based on the criteria points and quarters. column G:I are the actual, while column K:M is manually encoded just to show my desired output. i read and tried this reverse lookup to get column headers, (Q1,Q2,Q3,Q4). is there a way to get the players (P1-P9) based on criteria points and quarters?

    heres the code for the getting column headers based on players & pts.

    =INDEX(B2:E2,,MATCH(D15,INDEX(B3:E11,MATCH(C15,A3:A11,0),),0))

    Attachment 700142
    Attached Files Attached Files
    Last edited by jnsorrera; 10-18-2020 at 02:14 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,006

    Re: find row header based on table and column headers reverse lookup index & match

    A picture is worth 1000 words, a sample sheet is worth 1000 pictures!!

    You have attached a non-editable picture of an Excel sheet. That's not very easy to work with. Also... I'm lazy. I have to re-type your information before I can begin to address your problem. That puts me off completely.

    So.... Do yourself a favour and please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough). However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever).

    Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Make sure confidential information is removed first!!!!
    Glenn



  3. #3
    Registered User
    Join Date
    12-03-2019
    Location
    philippines
    MS-Off Ver
    2016
    Posts
    2

    Re: find row header based on table and column headers reverse lookup index & match

    Thanks glenn for informing me.

    however. i do lucky that i solve my problem using this code.

    =INDEX(A3:A11,MATCH(D15,INDEX(B3:E11,0,MATCH(C15,B2:E2,0)),0))


    il be now closing the thread

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,006

    Re: find row header based on table and column headers reverse lookup index & match

    Edit: double post.

    Glad you got sorted.

+ 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] Dual Reverse Lookup [Row & Column Headers]
    By Paddy_Bear in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-30-2018, 04:09 AM
  2. [SOLVED] Lookup (index/match) and return column headers
    By Barslund in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-08-2017, 06:01 AM
  3. Reverse Index Match -- Find column and row numbers for a table
    By mlukich in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2016, 02:16 AM
  4. Using Lookup? Index match? to populate cells based on column header
    By NoExcelSkills17 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-15-2015, 03:50 PM
  5. [SOLVED] Index & Match for multiple Column and Row to find header...
    By mr-c in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-31-2014, 08:24 AM
  6. [SOLVED] Reverse Lookup to Return Column Header (Date)
    By jeversf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2013, 12:27 PM
  7. Match/Index/Lookup - Searching From Bottom to Top (A reverse lookup maybe)
    By Neutralizer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 03:55 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