I have an existing SharePoint custom list with various columns. I require an additional column that is a lookup to a list in another site collection which I'm aware is not possible OOTB. How can I achieve this? After searching the web I have only seen options to get information from another site collection and put it in a web part, but I need the lookup to be a list column.
I'm aware this will likely require some form of customizations / custom code - please go easy on me with easy to follow instructions as I've never delved into customizations before.
I'm using SharePoint 2013.