I am using two spreadsheets and need to return multiple cells into one cell.

I have been using vlookup to return single results and using surnames as the
common cell in both spreadsheets. I want to continue using the surname to
link to the other spreadsheet but look at four columns of data in spreadsheet
1 and return into one column in spreadsheet 2 separated by commas.

I hope this makes sense.

Thanks