Hiya,
Having trouble with this one. I've looked all over and been unable to make anything I've found work for me.
I have a lookup spreadsheet with computer names on it in one column, and a list of users that have logged on in the adjacent column (separated by commas), which is a mix of USER IDs and Normal Names.
On my main spreadsheet I have two columns, one the name of the user, and the other the USER ID of the user.
I have created a new column on my main spreadsheet, and I want to basically search for the USER ID of each user on the lookup spreadsheet, and return every computer name that they have used in a concatenated list (comma separated).
I'm looking for a formula for this (can be an array formula). Ideally I don't want to have to use helper columns / cells.
I have attached an example workbook.
Thanks for your help in advance.
Having trouble with this one. I've looked all over and been unable to make anything I've found work for me.
I have a lookup spreadsheet with computer names on it in one column, and a list of users that have logged on in the adjacent column (separated by commas), which is a mix of USER IDs and Normal Names.
On my main spreadsheet I have two columns, one the name of the user, and the other the USER ID of the user.
I have created a new column on my main spreadsheet, and I want to basically search for the USER ID of each user on the lookup spreadsheet, and return every computer name that they have used in a concatenated list (comma separated).
I'm looking for a formula for this (can be an array formula). Ideally I don't want to have to use helper columns / cells.
I have attached an example workbook.
Thanks for your help in advance.