We can conduct our search with XLOOKUP by applying multiple criteria. To do so, there are two main approaches: concatenation and boolean expressions.