## XLOOKUP with boolean or logic

Learn how to use the XLOOKUP function with Boolean expression (OR logic). To do that set the lookup value to 1. XLOOKUP is our favorite dynamic array function, and you can use it in various situations. Generic formula to use a boolean or logic In the example, our goal is to find and list all … Read more