Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
How can I use calculated column to return a value from another list in SharePoint?
You can't. Calculated columns only work with the current list, with the current list item.
Required, but never shown