I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2.
Well I have!
With the MATCH function you can verify if a cell´s item in List1 exists in List2.
The function will return the row position of that item in List2 hence confirming that it exists. If you get a #N/A it means that the cell´s item does not exist in List2.
You can then go ahead and filter your List1 with either the values returned or the #N/As.