Hi all, I have a GSheet with two tabs 'Sheet 1' and 'Raw Data'. I need to Look up an 'Opportunity Number' from Sheet One (column A) and find this in 'Raw Data Tab' (Column A) and Return Multiple 'Partners' from 'Raw Data tab' (Column B). Please see attached Mini-Sheet, I need the results in one Row on Tab Sheet 1 (B:F) with 'No Partner' where there is no data, OR, Can have the Results concatenated into one cell (EG B10:B12) with punctuation separating results (does not matter what punctuation). 'Sheet 1' will be used for many other Data sets and formulas, it will be a sheet used by many Users so need to ensure I can present this data in a single row. Not sure I can do this without using a Table or FILTER function, so rather than muck around for ages I thought I'd ask the experts! NOTE: Apologies I cannot download XL2BB currently due to restrctions from my Company, so have added images instead.