Extract information

Hi, 

I am looking to extract all values in a column that match a criteria. I have been using the FILTER function to do this easily in a system with Office 365 access but I am trying to do a similar action in a Microsoft Office Professional Plus 2016 account and it doesn't work. Is there an alternative function or feature which will help me achieve the same?

For example, I have a set of information under Country A with two columns the id number and the measurements. What I am looking for is : When I enter the id number in a search tab, it pulls all the measurements associated (not just one).

COUNTRY A

ID        MEASURE

1           BBB

2            CCC

3            FFF

1            GGG

1            LLL

So the action would be, 

ENTER ID : 1

Expected result : 

BBB

GGG

LLL