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],Table1[Number],"NA")
but the result is the first Number of the related Colum, Why the formula not catch all the value with same condition?
Thank you,
1 Reply
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.
