Format control data - values to be input differently on different tabs

Yes, the array entered formula* that populates the 'Name' column is:

Formula:

=IFERROR(INDEX('Holiday Sheet'!$A$3:$A$16, MATCH(0, IF(MONTH('Holiday Sheet'!$B$3:$B$16)<>4, 1, COUNTIF(A$1:A1,'Holiday Sheet'!$A$3:$A$16)), 0)),"")

The formula that populates the 'Holidays' column remains pretty much the same.
*Array entered formulas are 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.
Let us know if you have any questions.

Originally Posted by JeteMc

Yes, the array entered formula* that populates the 'Name' column is:

Formula:

=IFERROR(INDEX('Holiday Sheet'!$A$3:$A$16, MATCH(0, IF(MONTH('Holiday Sheet'!$B$3:$B$16)<>4, 1, COUNTIF(A$1:A1,'Holiday Sheet'!$A$3:$A$16)), 0)),"")

The formula that populates the 'Holidays' column remains pretty much the same.
*Array entered formulas are 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.
Let us know if you have any questions.

tHANK you JeteMC. This seems pretty good! thank you so much. rep added :-)