I can only use SELECT and not LOOKUP
I thought that SELECT and LOOKUP where basically the same thing and can be used interchangeably.
In the first ss I have a formula where I SELECT a facility. When I try to replace the SELECT with a LOOKUP, it give me an error.
The second ss is an image of the list hierarchy.
Why does this happen? Is there anything I can do or do I have to use SELECT? (I would prefer not to)