So I have a list of user ids on one worksheet. On another worksheet, I have a field called receivers that may contain a single user id or multiples that are separated by commas like so: AAA1234,BBB1234,CCC1234. I need to be able to search each cell in the receivers column and match the user id I provide on the first sheet to one of these cells, and then show data from another cell. I was attempting to use index match, but it isn't a direct match. I have setup a basic idea below with everything on one sheet.
<tbody>
</tbody>
So I want to search for each UserID in column A and find it in column B, then return the value from column C.
Thanks for all help in advance and sorr if this is confusing.
A | B | C |
UserID | Receivers | Return Value |
AAA1234 | DDD1234,CCC1234,EEE1234 | 1 |
BBB1234 | AAA1234 | 2 |
CCC1234 | BBB1234 | 3 |
<tbody>
</tbody>
So I want to search for each UserID in column A and find it in column B, then return the value from column C.
Thanks for all help in advance and sorr if this is confusing.