Forum Discussion
not_a_pro
Oct 17, 2022Copper Contributor
How do I utilize a lookup table?
I have a lookup table of all customer office information. I am creating several lists where the user has to input their office ID when submitting a query. When I create the list, I am utili...
- Oct 17, 2022
not_a_pro
"Lookup" columns in SharePoint can only reference data from other lists not other datasources.
But you can quite easily create a new list based on an Excel file
Then you can create a lookup to that list.
But this works only once (when you create the list)... After that you will have to make updates on your office ids in that list, not in your excel file.
But you can always sync data from that list back into your Excel File.
SvenSieverding
Oct 17, 2022Bronze Contributor
not_a_pro
"Lookup" columns in SharePoint can only reference data from other lists not other datasources.
But you can quite easily create a new list based on an Excel file
Then you can create a lookup to that list.
But this works only once (when you create the list)... After that you will have to make updates on your office ids in that list, not in your excel file.
But you can always sync data from that list back into your Excel File.