I need to lookup rows from sheet 1 to construct a list in sheet 2 but I only want data from rows that match a certain criteria, and I do not want any empty rows:

Example: Criteria is "Type 3"

Sheet1:

A1 "CarA", B1 "Type 2"
A2 "CarB" B2 "Type 3"
A3 "LorryA" B3 "Type 3"

I would like this to produce the following in sheet 2:

A1 "CarB" B1 "Type 3"
A2 "Lorry" B2 "Type 3"

Anyone?

Thanks