• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fetch column headers for each col containing an "x" and one criteria

N

Norge

New Member
I have two sheets in this file, the first sheet, "DIST", has "x"s in various columns marking the channel for which the product (Col A.) is sold. For the second sheet "CHANNEL" I would like to return the column headers from the "DIST" sheet for those columns that have the "x" based on the criteria of product ("Gum" in Col. A on DIST tab matches "Gum" in Col A of "CHANNEL" tab). I have tried various syntaxes of INDEX, MATCH, COLUMN and ROW, but have not been successful. I manually filled in the "CHANNEL" sheet to show what it should look like with a successful formula.
 

Attachments

  • Return column headers when COL marked X.matchcriteria.xlsx
    11.1 KB · Views: 1
Brilliant as always Narayan. I've seen your responses to other queries and they are always super helpful. Thank you, this works perfectly!
 
You must log in or register to reply here.
Back
Top