Lookup against another ID

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.