it is my first request for help after I tried everything but could not find a solution.
I have 2 databases: Persons and Venues. A person can be assigned to more than one venue, therfore I have in the Persons DB a column Venues. In another column I would like to add the Venue-IDs, to be found in the Venues DB.
The lookup formula I created is
This does not work, because the given fields are in the wrong database. Is there another similar formula I could use in this case?
Thanks a lot in advance,