issue with VSTACK formula

Good afternoon All,

I have a formula in cell A6 tab "Kitting Schedule" that I can't get to work. It should pull data based on date from cell A2 and by the qty entered into cell B2, but it isn't for reasons that I can't figure out. I have included this file and would appreciate any guidance! There is a password on these sheets- "schedule" without the quotations.

Thank you in advance,

Adam

The problem is with your options, the formula is ok.
Check this part (Table3[DateRecieved]<>"")

I made some changes in your Table3 to test.

What did you have to modify to get it to work?

Thank you in advance!

Adam

The problem with your source data in Table3 is that all Table3[Kitting]="Yes" have no date in column Table3[DateRecieved], so there is no match.

Your formula.
=LET(v,VSTACK(FILTER(CHOOSECOLS(Table3[[Due Date]:[Notes]],4,2,12,5,1,13), (Table3[Due Date]>=A2)*(Table3[Kitting]="Yes")*(Table3[DateRecieved]<>"")*(Table3['#OfKits]>=B2);""); FILTER(CHOOSECOLS(Table35[[Due Date]:[Notes]];4;2;12;5;1;13); (Table35[Due Date]>=A2)*(Table35[Kitting]="Yes")*(Table35[DateRecieved]<>"")*(Table35['#OfKits]>=B2),"")),SORT(FILTER(v,INDEX(v,,1)<>""),5))

Tks for the feedback, glad to have helped.