Xlookup - Why only a info?

[LDS80]

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,

@LDS80 

[#2]

@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.