Return multiple matching values based on one criteria

[jaystarrr]

So I'm making a content marketing plan for the year and would like to make a week view that pulls from the Category on main sheet...

File is posted

Main:
Year Month Week Day Date Time Category
2021 January 53 Fri 1
2021 January 53 Sat 2
2021 January 53 Sun 3
2021 January 1 Mon 4
2021 January 1 Tue 5 Update
2021 January 1 Wed 6 Newsletter
2021 January 1 Thur 7
2021 January 1 Fri 8
2021 January 1 Sat 9
2021 January 1 Sun 10
2021 January 2 Mon 11
2021 January 2 Tue 12 Newsletter
2021 January 2 Wed 13 LinkedIn
2021 January 2 Thur 14
2021 January 2 Fri 15 Instagram
2021 January 2 Sat 16
2021 Januar 2 Sun 17
2021 Januar 3 Mon 18
2021 Januar 3 Tue 19 Update
2021 Januar 3 Wed 20
2021 Januar 3 Thur 21 Update
2021 Januar 3 Fri 22


Week
1 2 3 4 6 7 8 9
Update Newsletter
Newsletter LinkedIn
Instagram



10 11 12 13 14 15 16 17

[Bo_Ry]

Please select B4:I4

Enter formula
=FILTER(Tabel26[Category],(Tabel26[Week]=LOOKUP(99,B$3:B3))*(Tabel26[Category]>0),"")
Press ctrl+Enter

copy to B11:I11

[jaystarrr]

Very nice - that worked! Been seraching forever! Was trying some INDEX and TEXTJOIN funktions, that just never quite worked.

Thanks!