Loading…
Loading…
Set XLOOKUP's match_mode to 2 to allow wildcards: * stands for any number of characters and ? for exactly one. Handy for partial names. Join a wildcard to a cell with &, for example F2&"*".
Syntax
XLOOKUP("Lap*", B2:B6, C2:C6, "none", 2)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.