LOOKUPVALUE with duplicates

Hello,

I currently have one table with an "Order ID" that can, sometimes, have an "Original Order ID", while being an "Order ID"itself. This "Original Order ID" can have more than one "Order ID" inside. I've tried using LOOKUPVALUE but get the "table with multiple values" error.

Both columns could contain duplicates.

I'm trying to create column that flags all "Order ID"s that are also "Original Order ID"s. Something like the "Contains Another Order" column.

Thanks in advance.

You can see an example of the desired result below.


Order ID      |Original Order ID |Contains Another Order