Multidimensional lookups
3-hour applied workshop covering multidimensional lookups: diagnostic, guided practice and skill checks.
- Identify the role of “XLOOKUP” in a workplace scenario.
- Identify the role of “XMATCH” in a workplace scenario.
- Identify the role of “INDEX and MATCH” in a workplace scenario.
- Apply the practice used to look up a value and return a nonadjacent column.
- Verify and justify the choice of “XMATCH” to return the relative position of a lookup item.