#N/A related to XLOOKUP with multiple criteria and structured reference

%3CLINGO-SUB%20id%3D%22lingo-sub-1634472%22%20slang%3D%22en-US%22%3E%23N%2FA%20related%20to%20XLOOKUP%20with%20multiple%20criteria%20and%20structured%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634472%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eim%20having%20problems%20with%20a%20XLOOKUP.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20if%20the%20employees%20who%20logged%206%20or%20more%20hours%20of%20delivery%20also%20logged%20a%20break%20(labourlaw%20compliance).%20The%20table%20contains%20log_date%2C%20user_name%2C%20task_name%20and%20log_time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DXLOOKUP(%5B%40%5Blog_date%5D%5D%26amp%3B%5B%40%5Buser_name%5D%5D%26amp%3B%5Btask_name%5D%3D%22Break%22%3B%5Blog_date%5D%26amp%3B%5Buser_name%5D%26amp%3B%5Btask_name%5D%3B%5BSum_log_time%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20i%20wrote%20so%20far%2C%20but%20i%20always%20get%20the%20%23N%2FA-Error%20or%20sometimes%20%23Value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20handle%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1634472%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1634812%22%20slang%3D%22en-US%22%3ERe%3A%20%23N%2FA%20related%20to%20XLOOKUP%20with%20multiple%20criteria%20and%20structured%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F781865%22%20target%3D%22_blank%22%3E%40PWACC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20it%20shall%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DXLOOKUP(%5B%40%5Blog_date%5D%5D%26amp%3B%5B%40%5Buser_name%5D%5D%26amp%3B%22Break%22%3B...%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hey guys,

 

im having problems with a XLOOKUP.

 

I want to know if the employees who logged 6 or more hours of delivery also logged a break (labourlaw compliance). The table contains log_date, user_name, task_name and log_time.

 

=XLOOKUP([@[log_date]]&[@[user_name]]&[task_name]="Break";[log_date]&[user_name]&[task_name];[Sum_log_time])

 

This is what i wrote so far, but i always get the #N/A-Error or sometimes #Value.

 

Does anyone know how to handle this?

 

Thanks!

 

P

1 Reply
Highlighted

@PWACC 

Perhaps it shall be like

=XLOOKUP([@[log_date]]&[@[user_name]]&"Break";...