Trouble with XLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-2148657%22%20slang%3D%22en-US%22%3ETrouble%20with%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148657%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20with%20the%20XLOOKUP%20formula%20on%20a%20simple%20workbook%20I%20use%20to%20track%20the%20details%20of%20different%20jobs%2Finvoices.%26nbsp%3B%20One%20sheet%20has%20the%20invoices%20listed%20with%20the%20details%20while%20the%20other%20sheet%20has%20a%20running%20list%20of%20expenses%20with%20a%20list%20and%20its%20association%20to%20an%20invoice.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUM(XLOOKUP(%24E6%2CExI%2CExV))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EI%20have%20the%20cells%20carrying%20the%20invoice%20label%20named%20ExI%20while%20the%20cells%20with%20the%20expense%20value%20named%20ExV.%26nbsp%3B%3C%2FP%3E%3CP%3EDespite%20trying%20to%20get%20a%20total%20of%20the%20expense%20I%20only%20get%20one%20value%20returned%20in%20the%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2148657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2148839%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F964129%22%20target%3D%22_blank%22%3E%40ar3inc%3C%2FA%3E%26nbsp%3BI%20believe%20you%20need%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUMIF(ExI%2C%24E6%2CExV)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ein%20stead.%3C%2FP%3E%3CP%3EXLOOKUP%20returns%20a%20single%20value%20as%20explained%20in%20the%20MS%20help%20section%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-19%20at%2011.31.40.png%22%20style%3D%22width%3A%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256002iED9616891C990BBD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-19%20at%2011.31.40.png%22%20alt%3D%22Screenshot%202021-02-19%20at%2011.31.40.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am having trouble with the XLOOKUP formula on a simple workbook I use to track the details of different jobs/invoices.  One sheet has the invoices listed with the details while the other sheet has a running list of expenses with a list and its association to an invoice.  

=SUM(XLOOKUP($E6,ExI,ExV))

I have the cells carrying the invoice label named ExI while the cells with the expense value named ExV. 

Despite trying to get a total of the expense I only get one value returned in the cell.

1 Reply

@ar3inc I believe you need:

=SUMIF(ExI,$E6,ExV)

in stead.

XLOOKUP returns a single value as explained in the MS help section:

Screenshot 2021-02-19 at 11.31.40.png