I have two lists in two SharePoint site collections. The source list includes a rich text
column which I need to display in destination list in other site collection. When I use look up column in destination list I cant see the source list because it is not in the same site collection. How can I accomplish this task?
Lookup column option is not available in OOB if it is in different site collection. You need to implement custom solution for this. Please check the references below.