Return array of values based on text

Hi,

I'm creating a holiday planner that has dates in one row from Jan-Dec and a list of names in column A.

I am trying to create a report on a separate sheet that returns all dates based on a the code entered in the rows beneath.

I'm currently using this:

Please Login or Register  to view this content.

where B25 has the value of the fist code, in this case "H" (for Holiday)

This works great for the first entry of the letter "H" and returns the date above as expected.

Can someone point me in the direction to return all occurrences in the row that have a "H" below.

Your help is much appreciated.

One way is using INDEX with SMALL(IF, as an array formula.

If this is accepted, pls upload a small sample workbook.

There has to be a better solution, but once your data is in landscape mode, convert them to vertical and have the desired effect.

See the example.