Formula to copy data based on criteria

My brain hurts this morning. I've been trawling the web and can't see a solution for a relatively simple criterion-based copy/paste. The spreadsheet shows clearly the source data, the criteria used and the desired end result.

In short, if I want to select data in cells in one column, if the values in another column meet a criterion and copy the selected values to another location.

Can you help me (again...)??

See attached file. I've used this formula in F5:

Formula:

Please Login or Register  to view this content.

which is copied down the column beyond your data (the hyphens show how far). Then I've set your table up in columns N to Q (in blue), with this formula in N18:

Formula:

Please Login or Register  to view this content.

and this one in O18:

Formula:

Please Login or Register  to view this content.

which is copied across to Q18. Copy N18:Q18 down as far as you need to.

Hope this helps.

Pete