Forum Discussion

not_a_pro's avatar
not_a_pro
Copper Contributor
Oct 17, 2022

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's avatar
    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.

Resources