Match to multiple instances of a weekday

[svinet]

Hi Everyone.


I’m using MATCH to look up days in a month (as an example ever Thursday in June).
I have the dates at the top of each column from A:NB. (Cell Example> June, Thurs)
MATCH alone only shows me the first day of the week column location.
How can I show the column location of all of the days of the week that I’m looking for?

Thank you so much!

[ChemistB]

How come it only shows the first day of the week? How are your headers set up? Can you upload an example of how your data is laid out? (Go Advanced>Manage Attachments)

[svinet]

I added a sample sheet that has one month only.

How come it only shows the first day of the week? How are your headers set up? Can you upload an example of how your data is laid out? (Go Advanced>Manage Attachments)

[ChemistB]

Still not sure exactly what you are looking at but take a look at this
In A16, I put your criteria, in this case Jan, Thu
In A17, I used Data Validation to have a dropdown list of all the people.
In B17 copied to the right is this ARRAYED formula

=IFERROR(INDEX($B$2:$AF$13, MATCH($A$17,$A$2:$A$13,0), SMALL(IF(MONTH=$A$16, COLUMN(MONTH)-1), COLUMNS($A$1:A$1))),"")...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Is that what you are looking to accomplish?