+ Reply to Thread
Results 1 to 9 of 9

Index by Table Header

  1. #1
    Registered User
    Join Date
    03-02-2018
    Location
    Florida, US
    MS-Off Ver
    Office 2016
    Posts
    6

    Index by Table Header

    I know this is possible. Someone showed me once it can be done. For the life of me though I cannot remember. Any help? Thanks in advance!

    In the table shown (HFprocurement), I want to...
    1. Match TicketID number in FromHF table (Sheet "FromHappyFox")
    2. Index FromHF table where header matches header in HFprocurement table

    Capture.PNG

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

    Re: Index by Table Header

    Hello and welcome to the forum.

    Please attach a small representative sample of your data along with the desired results (which you can enter manually).

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Registered User
    Join Date
    03-02-2018
    Location
    Florida, US
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Index by Table Header

    I guess I can't attach anything until I post a few times. I'm a newbie to this forum. ;-)

  4. #4
    Registered User
    Join Date
    03-02-2018
    Location
    Florida, US
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Index by Table Header

    I am being told "You are not allowed to post any kinds of links, images or videos until you post a few times." although I am not posting any link, image or video.

  5. #5
    Registered User
    Join Date
    03-02-2018
    Location
    Florida, US
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Index by Table Header

    Sample attached
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-02-2018
    Location
    Florida, US
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Index by Table Header

    In cell H2 basically I want to index "FromHF[&H1&]"
    This way I can copy/paste the formula into other columns and not have to retype the index portion each time.

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

    Re: Index by Table Header

    Try this in H2 of the 'HF Procurement SLA' worksheet:

    =INDEX(FromHappyFox!$H:$AC,MATCH($A2,FromHappyFox!$A:$A,0),MATCH(H$1,FromHappyFox!$H$1:$AC$1,0))

  8. #8
    Registered User
    Join Date
    03-02-2018
    Location
    Florida, US
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Index by Table Header

    Wow, so easy. It's like I never noticed the column_num portion of the INDEX formula before. Makes total sense now. Thanks 63falcondude!
    INDEX(array, row_num, [column_num])

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

    Re: Index by Table Header

    You're welcome.

    I'm glad that you took the time to look into it to understand what is going on. Doing that will help you immensely.

+ 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. Index Match with Header and sub header
    By robstormbreaker in forum Excel General
    Replies: 2
    Last Post: 02-17-2017, 02:25 PM
  2. Why cant i refer with INDEX and MATCH to a table header
    By esahakos in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2016, 06:21 AM
  3. Helped needed to index match row header, column header, and sheet
    By vw103604 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2016, 12:37 PM
  4. [SOLVED] Table Header in Index to link to cell
    By Katch22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2014, 07:49 PM
  5. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  6. [SOLVED] Extract the column header given the row header and highest value in a subset of a table
    By pguarino in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2013, 02:05 AM
  7. Header index
    By Will Brown in forum Excel General
    Replies: 8
    Last Post: 12-09-2006, 08:58 PM

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