Populating table with data using multiple criteria

Hi,

I am attempting to populate multiple rows in one column with data from another table. I need to get the correct street address using multiple values, i.e. first name, last name and city, as some of the names double up.

Is there a way to do this? I have attached an example of what I need done as reference.

Thanks in advance,
Joey