Forum Discussion

Copper Contributor

Oct 17, 2022

Solved

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...

SvenSieverding
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

Bronze Contributor

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.