Create a distinct list based on other criteria

Hello,

I am trying to get distinct values from another worksheet based on a type of apartment unit. I have attached a sample worksheet.

Basically, what I do is export select apartment buildings to a template with an import worksheet. Each building could have all 1 bedroom units, 2 bedrooms units, etc or a mix of both. So it has the apartment complex name and then the averages for all of their 1 bedrooms, etc.
Then I have a table I use to put into a word report. There is a separate worksheet for 1 bedroom units, 2 bedroom, etc.
What I want to do is be able to have, for instance, the 1 bedroom table look at the import sheet, pick out the only the distinct apartment building names that match that have one bedroom units and list those in the table along with the corresponding 1 bedroom data. Same for the 2 bedroom sheet, etc. The 1 bedroom sheet has the data missing, the 2 bedroom sheet has a sample of what I am wanting it to look like.

Thanks in advance for any help,
Tom

Thank you for your quick response. I think I may be confused, so here goes. I used the first two formulas and they work great for getting the distinct names that correspond to which ever unit type sheet I'm using. My next problem is getting the corresponding data for each apt complex to populate the columns to the right of the complex name. So, using the example. If I put the formula and copy down starting in A4 in sheet 2 Bed Comps, I would like, as an example, for it to put in cell A5 Heatherton Apartments, then in column C5 put the average SF of the 2 bedroom apartments from the Heatherton Apartments (from the Import Unit Mix Comps worksheet cell C5) of 1,087. And so on through G5 of the 2 Bed Comps sheet.
I think I got confused where you had said to headings should be the same. Did the formulas you put in there afterward need to go in the corresponding columns?

Thanks! That worked Great!