To lookup values using two criteria, apply the boolean OR logic and get two possible outputs, TRUE and FALSE. For example, to find values in a two-column range where the name is “orange” or “blue”, use the following formula: =XLOOKUP(1, boolean_expression, data)