Results 1 to 7 of 7

Return multiple column headers based on a row value

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    4

    Return multiple column headers based on a row value

    Hi all,

    Using the Match and & formula, I managed to obtain the row number that match 2 criteria (all the combination of 2 criteria are unique so whenever you try a combination, you will get only 1 row that match these two criteria).

    So I get the row number of the particular combination of 2 criteria. What I want know, is the formula to check on the row whenever there is a A and if so, return the column header. There is 24 columns so I need the formula to return all the column headers.

    I guess it will involve array formula with Match and Index formula but honestly I can't see how to do it.

    EDIT: the columns header start at column C and the row number is between row 4 and 100

    Best regards,

    Alex
    Last edited by Algolik; 04-19-2017 at 07:20 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Return Multiple Column headers from row title and content?
    By loveridge01 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-11-2017, 05:16 AM
  2. [SOLVED] Return list of column headers based on cell value
    By akshaysudhir in forum Excel General
    Replies: 4
    Last Post: 04-17-2015, 06:10 AM
  3. Search for value in multiple columns, Return Column Headers
    By Zach51215 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2013, 06:49 AM
  4. [SOLVED] Return Column Headers based on row rank with duplicate values in row
    By carlwin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2013, 12:24 AM
  5. [SOLVED] Return multiple values from another workbook, based on Column Headers in other workbook
    By GoGators in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2013, 02:11 PM
  6. Replies: 11
    Last Post: 02-08-2012, 01:25 PM
  7. return a value based on column and row headers
    By jimmy1981 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2012, 11:02 AM

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