Forum Discussion
Xlookup - Why only a info?
Dear All, I'm building the following rules to keep a value in a cell, based on two condition (x=Time and Y=Status): =XLOOKUP([Time Cell] & [Status Cell],Table1[Procedure Time] & Table1[Status...
LDS80 But that what lookup functions do. The return a single value. Since you have XLOOKUP, you can also use FILTER. That function is used, as the name suggests, to filter out all information based on one or more criteria.