Hello,
I have 2 worksheets - Devices and Departments
worksheet Devices has a list of Device IDs in Column A
worksheet Department has a list of department names in column A and a comma-delimited list of device IDs associated with that department (123xyz, 126xyz, 127xyz, 128xyz) in column B
Is there a way to look up the device ID from the Devices worksheet column A in the Department worksheets column B and return all departments separated by a comma, associated with that device ID into adjacent cells in column B of the Devices worksheet?
Devices Worksheet
Department Worksheet
I have 2 worksheets - Devices and Departments
worksheet Devices has a list of Device IDs in Column A
worksheet Department has a list of department names in column A and a comma-delimited list of device IDs associated with that department (123xyz, 126xyz, 127xyz, 128xyz) in column B
Is there a way to look up the device ID from the Devices worksheet column A in the Department worksheets column B and return all departments separated by a comma, associated with that device ID into adjacent cells in column B of the Devices worksheet?
Devices Worksheet
| DeviceIDs (column A) | Departments Found In (column B) |
| 123xyz | Blue, Red, Yellow |
| 124xyz | Red, Yellow |
| 125xyz | Yellow |
Department Worksheet
| Department Name (column A) | DeviceIDs (column B) |
| Blue | 123xyz, 126xyz, 127xyz, 128xyz |
| Red | 123xyz, 124xyz, 129xyz |
| Yellow | 123xyz, 124xyz, 125xyz, 130xyz |
