I have been trying to work with VLookup and HLookup and this has not gotten me anywhere. So I am reaching out for possible solutions. Solutions in either general formula's or VBA would be welcomed.

The workbook:
I have a worksheet that contains a list in Column A (A3:A336 currently, this list will be expanding over time but not at a rate that will make manual manipulation of formulas difficult to define a new range or array). This same list is also posted as the header row, in Row 2 (B2:LW2); again this list will expand exactly as the list in Column A.

The reason for this layout:
The list is a grouping of documents. Document A may contain reference to Document B, while Document B does not contain reference back to A. If you look at information across a single row (still a single document) the worksheet will indicate what references that document contains. If you look at information down a single column (still a single document) the worksheet will indicate what other documents reference it. These two types of information are not always going to be the same. The reference/link is indicated by a "." in the cell which then prompts conditional formatting, turning both the period and the cell green, for an easy visual queue.

The problem:
What I am finding (although the idea works very well) is that my list can be very difficult to read and obtain any useful information, even though it is in fact capable of providing useful information. When looking down any individual column, the "Filter" function within Excel may be utilized; this consolidates the column down to only cells which have been colored as green - indicating a reference. However, when looking down any given row, there is no such "Filter" function (it only works on columns). This is where it becomes problematic because trying to filter through and look at 334 columns is not a "quick" task. Ideally this workbook will be a quick tool to easily look up references or linkages.

Solution? (others most definitely will exist)
1) Generate formulas or code that will perform an advanced search/filter (basically generate a "Filter" feature but for rows not columns)
1A) Look up a value in column A
1B) Search the row where that value is contained for other entries (So if 004 is on row 6, search all of row 6)
1C) Return the Row 2 column header associated with the cell (if M6 is marked as a reference/link, the resulting response would be to return "M2")
1D) Replicate for each instance of a marked cell (if in row 6 there are 8 marked entries, there should be 8 returned Row 2 titles to indicate the documents which are referenced/linked

Does anyone know how to get Excel to filter rows?

I cannot actually post the spreadsheet or contents as the information is proprietary/confidential but I will check periodically to see if I can provide small chunks to help.