Lookup against another ID

Copper Contributor


I have an app the sends details to two sharepoint lists - personal details and shop orders.


Can I add a lookup column that will bring the name from personal details to shop orders list?


I have an orderID column in both lists.



2 Replies

@rosscortb Yes, you can create list relationships by using lookup columns in SharePoint online.


You can add a lookup column from personal details list to shop orders list and select additional columns to show in shop orders list. However, you can extend limited column types like single line of text, number, date, currency, etc.


Check this documentation for more details: Create list relationships by using lookup columns 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.



Thanks for your response but not sure the links shows how I can achieve this.


As you can see I have added a lookup column in order list which does bring through the employee names for the personal details but I want it to auto fill when the items are added. I suppose in excel it would be a vLookup using the orderID as the unqid.