Help populating from a list with criteria

[Ksun23]

Please see updated post below...

I've attached a sample sheet with data and desired result. I need columns to populate from a master list based on the criteria in the adjacent column. I also need it with no duplicates and to continue to populate as more items are added to the master list. I tried an index,match,countif but could not get it to work, and was using CSE with it.

Appreciate any help

Thanks

[benishiryo]

hi there. try this array formula:
=IFERROR(INDEX($B$5:$B$15,MATCH(0,IF($A$5:$A$15=D$4,COUNTIF(D$4:D4,$B$5:$B$15)),0)),"")

to continue to populate as more items are added, it might be easier to convert your master list to a Table prior to doing the formula. select A5:B15 and press CTRL + T. a header will be added and if you re-ranged the formula, it will look something like:
=IFERROR(INDEX(Table2[Column2],MATCH(0,IF(Table2[Column1]=D$4,COUNTIF(D$4:D4,Table2[Column2])),0)),"")

if you're interested, this formula is explained in the file of my link below*Tips & Tutorials I Compiled, sheet 2

[Ksun23]

Works great, very much appreciated.

Huge thanks!

[Ksun23]

Updated question.

My original problem was solved but I need help expanding the formula. I need multiple criteria.

I tried changing IF to IFS to add the 2 extra logical tests for the date range and used >= and <= for beginning and end date but it just returned a blank cell.

Hoping I can get some extra help on this please.

Updated sheet is attached.

Thanks in advance