All results from Multiple columns

[RHudson714]

TIA!!

I am trying to create a budget calendar and I have a worksheet with the list of bills to be paid. One column has a set day(Sun-Sat) and another column has a constant day(1,2,3,4....) for the same day of the month the bill is due. I am using index & small to look in the columns to get all values. My issue is that I need to return all results from both columns in my calendar. I am able to get results from one column or the other but not both. I'm having trouble writing the formula for the offset once it's finds the last result in the first column to start back at row 1 in the second column.

Formula for Weekday column:
=IFERROR(INDEX('Bill Payment and Holidays'!$F$8:$F$17, SMALL(IF(Monthly!K$2 ='Bill Payment and Holidays'!$C$8:$C$17, ROW('Bill Payment and Holidays'!$F$8:$F$17 )- 7,""), ROW() - 3 )),"")

Formula for the MonthDay Column:
=IFERROR(INDEX('Bill Payment and Holidays'!$F$8:$F$17, SMALL(IF(DAY(Monthly!N$3) ='Bill Payment and Holidays'!$D$8:$D$17, ROW('Bill Payment and Holidays'!$F$8:$F$17 )- 7,""), ROW() - 3 )),"")

These are arrays confirmed with Ctrl+Shift+Enter

 

[RHudson714]

Bump