R
Rodders
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
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