Xlookup - Why only a info?

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3167205%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EXlookup%20-%20Why%20only%20a%20info%3F%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3167205%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EDear%20All%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20building%20the%20following%20rules%20to%20keep%20a%20value%20in%20a%20cell%2C%20based%20on%20two%20condition%20(x%3DTime%20and%20Y%3DStatus)%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3DXLOOKUP(%5BTime%20Cell%5D%20%26amp%3B%20%5BStatus%20Cell%5D%2CTable1%5BProcedure%20Time%5D%20%26amp%3B%20Table1%5BStatus%5D%2CTable1%5BNumber%5D%2C%22NA%22)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ebut%20the%20result%20is%20the%20first%20Number%20of%20the%20related%20Colum%2C%20Why%20the%20formula%20not%20catch%20all%20the%20value%20with%20same%20condition%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1304567%5C%26quot%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%40LDS80%26lt%3B%5C%2Fa%26gt%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3167205%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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 

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.