looking up data and displaying it in another sheet depending on selection criteria

[westie1871]

Hi,
I currently have an Excel spreadsheet one sheet has a listwith all my job data. I have a separate sheet with my selection criteria andthen I wish to populate another sheet based on the selection criteria do youknow if this is possible if so how do I go about doing it.

For Example: -
Data Sheet
Date |JobNumber | Postcode | Weight | units
01/03/2018 12345 WA65 9BP 100 1
02/03/2018 23456 M25 200 3
Then my Selection Sheet

Route 1 Route2
WA65 M25


So I want to look at the first set of DATA then look at myselection sheet and then post the results into another sheet either in route 1or route 2

I hope this explains my problem.

Thanks in advance