Upserting Salesforce Records

Was just asked what are the key types that can be used for inserting values.
understood that we can use the external id, id and something new idlookup.

Need to figure out more on what the IdLookup is.