Returning column headings that have the lookup value of Y

I have a list of accounts that have various criteria columns with Y or N in them. I've created a lookup tab in the file to make it easier for someone to types in the account number and they know some specifics about it. What I want to do is have it list all the columns where there is a Y and state what the column is in a top down list. Thanks for any help!