Formula to extract cell values depending on other cells

Hi

I have a list of order lines and need to transfer data to another sheet if the order contain certain items.

Here's an example of data in the range A1:D8:

ON Customer Product Price
1 Customer 1 Phone 500
1 Customer 1 Headset 30
1 Customer 1 Charger 20
2 Customer 1 Headset 30
3 Customer 2 Phone 500
3 Customer 2 Headset 30
4 Customer 3 Charger 20

If the order (Order Number = ON) contain a phone i need to transfer it to the same range in a new sheet.

So for my example i should get this data in my new sheet:

ON Customer Product Price
1 Customer 1 Phone 500
1 Customer 1 Headset 30
1 Customer 1 Charger 20

3 Customer 2 Phone 500
3 Customer 2 Headset 30


Orders 2 and 4 did not fit the criteria and is left out.

I have been able to transfer other data with a simple IF and let it return "" if my criteria is not met and this works perfectly for the setup I need.
But since my criteria in this case does not only concern the row but the order as a whole, I'm stumped

Hope someone can help.

Thanks

Gekko

Brilliant.

I have so many countifs in the workbook already, but never thought of using it like this.

Thanks a lot