Hi Kl2x07,

welcome to the forum.

Try using below formula:-

Formula: copy to clipboard 
=IFERROR(INDEX('Works record'!B$1:B$134,SMALL(IF('Works record'!$A$1:$A$134='Works in your area'!$B$10,ROW('Works record'!$A$1:$A$134),""),ROW($A1))),"")


enter this with key combination: ctrl shift enter

see attachment:- sample(2).xlsx


Regards,
DILIPandey
<click on below * if this helps>