Spreadsheet and address: how to filter based on a range

Question

I have a spreadsheet with thousands of entries. I need to extract some data from it based on the content of another spreadsheet.

The file looks like this:

   ID    Location   Address

------   ------  ------------

000001   London   Oxford St.

000002   London   Ladbroke Sq.

000003   London   Beryl Rd.
...       ...        ...

On a second sheet I have a list of address. What I need to do is to filter the content of the first sheet based on the address I listed.

I thought ARRAYFORMULA could the the work but I'm stuck with this:

=ARRAYFORMULA(SUM(((Sample!$A:$A)=$A2) * ((Sample!$B:$B)=B$1) * (Sample!$C:$C) ))

Answer 1

If your data on the first sheet looked something like this:

One option would be INDEX(MATCH()) on the second sheet:

Another option - creating a separate column for filtering in the first sheet:

Too bad conditional formatting formulas do not work when they take references from another sheet.