Arrays help

i need to summarise data by essentialy extracting and writing the valuable information from a 'raw data dump' after refering to a list of values which are required on another 'summary' tab on a fixed table format. i need these cell on the summary tab to look at the list of values and if it finds these in a fixed column in the 'data dump' then it pulls a number of different values on the same row and and drops them in the summary table on a single row in specific cells which are non consectutive.

i know it is an array formula which is required, just cannot work out how to write it.

thanks very much for any help available.