I am trying to implement the lookup function to check the selected value from a drop down and
then show me the result from column Manager.
The cost center is a lookup function which looks at a list on a different page. My idea behind is so that when a cost center number is selected from the drop down, then it should show the relevant manager.
The CostCentre list contains Cost Cetre Nr | Manager | Exec etc.
The problem is for me how to make the lookup fetch the data from a list on a different page??
This is the url to the actual list: https://domain.com/X/Lists/CostCentre/AllItems.aspx
I have tried the following as a calculated function:
lookup("https://domain.com/X/Lists|CostCentre ", "ID",CostCentre,"Manager")
the result states "Loading..." but no results showing.
Any advise in what I am doing wrong .... ???