Microsoft Lists app on Sharepoint: trying to figure out lookups, can't find documentation

Demani

Ars Praefectus
5,318
Subscriptor++
Part of the issue I think is that Microsoft and Lists are too generic, particularly since Sharepoint seems to consider everything "lists". So maybe I'm my Bing Fu is week (Google Fu too).

The immediate goal is to work on a list that can look up locations from a list (a simple flat list in Excel that interns can add to would be fine).
But the Lookup column type seems to look up from Sharepoint "lists" only, so the straightforward option seems to be to create a "List" that people can enter into (or at least add to once a spreadsheet is imported).

But in that vein, is there any good repository for training? I found one video on LinkedIn training, and some super basic training videos on the MS site. I can't find any books either, but should I be looking for Sharepoint training more than Lists training? And of course they'll probably ditch it in 2 years.