How to create a cell of IDs of related products (in the row of an original product)?

Because I only want to display the related product IDs in column C if the original ID ends on one of these 4:

- regular 7 digit IDs (for example: 801_005)
- 850_176 (for example: 801_005 - 850_176)
- 850_177 (for example: 801_005 - 850_177)
- 850_230 (for example: 801_005 - 850_230)

You can see that my examples are the same products because all of them start with 801_005 only they are different variations. And ultimately I would only want to display the related products in column C of items that end on those above mentioned 3 numbers + the original regular ID (801_005)

EDIT: Maybe it´s a solution to exclude in the function somehow products that have IDs ending on 240, 247, 261 and 74?