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 utilizing the 'choice' column; but is there a way to reference a datasheet (excel) that has the current customer office ID's? As an example, we add/deleted(archived) 20+ office ID's a year and I need the list selection to be dynamic to what is added.
I see the option for 'Lookup' but it seems to only reference other libraries/lists and not actual data tables such as excel.