+ Reply to Thread
Results 1 to 4 of 4

Trying to find column header based on row search value for multiple intersecting points

  1. #1
    Registered User
    Join Date
    10-18-2016
    Location
    Calgary, Canada
    MS-Off Ver
    2010
    Posts
    5

    Question Trying to find column header based on row search value for multiple intersecting points

    Hello,

    I could use a little help here. I've tried different formulas I've found through these threads but just can't get anything to work. I'm looking for formulas that could get me where I need to get, not looking for a vba script.

    I've attached an image of what I'm looking at, and for.
    Capture.JPG

    I want to search by column A and find all instances of x across the row, and then have the results show all column headers where x is found.
    My search value is in B9, and hoping to get the results in B11:B17.

    Thanks,
    Ric

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Trying to find column header based on row search value for multiple intersecting point

    Try array entering this formula in B11 and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    10-18-2016
    Location
    Calgary, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Trying to find column header based on row search value for multiple intersecting point

    That worked like a charm, thank you!

    I added an IFERROR to keep the B15:B17 cells blank if no return value.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Trying to find column header based on row search value for multiple intersecting point

    Good call. Thank you for the feedback, added rep and marking your thread Solved.

+ 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: 2
    Last Post: 03-30-2017, 08:54 PM
  2. [SOLVED] Search for a column based on a header name and then searching only that column
    By sokeefe14 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2015, 10:51 AM
  3. [SOLVED] Find Row in Table based on Column Header
    By thisguy4000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2014, 12:55 PM
  4. [SOLVED] Find value in row and column and get intersecting data
    By coopman64 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2014, 10:34 PM
  5. Find Column Number Based on Column Header
    By chicagoland8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2014, 11:58 AM
  6. Sum column values based on intersecting criteria in row and column
    By rlbush2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2013, 03:56 PM
  7. Search for column header and find all values and their row numbers in that column
    By woody83 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2012, 03:11 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