In SharePoint Online modern experience, you can connect two lists web parts based on common column & perform dynamic filtering.
For more information, check below documentation:
Connect web parts in SharePoint
This is a SharePoint out of the box (& easy) solution. So it will not give you a dropdown with list items.
You can edit the list web ...