The topic may be old but I am having a difficulty with a lookup value.
I am trying to use lookup to look at a different subsite by using the URL address.
the aim is to pull the Manager's name based on the dropdown field : CostCentre but the result shows #Value!
There is a list named to Cost Centre as a custom list is and when you go to the list it shows the following URL
I also tried as following: https://sp.domain.com/A/Lists/Cost%20Centre but nothing helps.