Google Sheets – Arrayformula with textjoin


I’m trying to figure out how to make my arrayformula with textjoin to work, but I’m kind of lost.

enter image description here

What should be done is that F3 to F5 should have a formula attached, so it displays as showed. The formula need to check for the Payment in column E, date in cell E1, to match with corresponding order from column B & C.

My formula looks as following right now:

‘=ARRAYFORMULA(TEXTJOIN(“, “;TRUE;IF(Orders!C:C = “Visa”;Orders!A:A;””)))

I don’t know how to also account for the date in cell E1.

Any Google Sheets pro’s out there who could help me out in a direction?

Would be thankful for any help!