Lookups—also known as mapping tables—work similarly to Excel’s VLOOKUP, allowing you to assign or insert a dimension in one database based on how it corresponds to a dimension in another.
How can I tell if a lookup is empty or has not been set?
Can I do lookups with driver values?
Can I set a lookup based on multiple dimensions?