Combined searching

%3CLINGO-SUB%20id%3D%22lingo-sub-2079125%22%20slang%3D%22en-US%22%3ECombined%20searching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079125%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EHaving%20a%20matrix%20of%20four%20columns%20(date%3B%20store%3B%20payment%3B%20value)%2C%20how%20can%20I%20search%20the%20cash%20value%20for%20a%20singular%20store%20in%20a%20specific%20day%3F%20Does%20Vlookup%20works%3F%20How%3F...%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3EJorge%3C%2FP%3E%3CTABLE%20width%3D%22560%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2246%22%3EDate%3C%2FTD%3E%3CTD%20width%3D%2240%22%3EStore%3C%2FTD%3E%3CTD%20width%3D%2241%22%3EPaym%3C%2FTD%3E%3CTD%20width%3D%2249%22%3EValue%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3Ecash%3C%2FTD%3E%3CTD%3E57%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EStoreA%3C%2FTD%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3E03%2Fjan%3C%2FTD%3E%3CTD%3E04%2Fjan%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3Ecards%3C%2FTD%3E%3CTD%3E60%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3EValue%3F%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3Ecash%3C%2FTD%3E%3CTD%3E72%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ECards%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3Ecards%3C%2FTD%3E%3CTD%3E61%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3Ecash%3C%2FTD%3E%3CTD%3E73%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2Fjan%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3Ecards%3C%2FTD%3E%3CTD%3E53%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3Ecash%3C%2FTD%3E%3CTD%3E65%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3Ecards%3C%2FTD%3E%3CTD%3E75%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3Ecash%3C%2FTD%3E%3CTD%3E55%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3Ecards%3C%2FTD%3E%3CTD%3E87%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3Ecash%3C%2FTD%3E%3CTD%3E75%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2Fjan%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3Ecards%3C%2FTD%3E%3CTD%3E62%2C00%20%E2%82%AC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2079125%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2079151%22%20slang%3D%22en-US%22%3ERe%3A%20Combined%20searching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079151%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F936276%22%20target%3D%22_blank%22%3E%40jlopes65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etry%26nbsp%3BSUMIFS%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi!

Having a matrix of four columns (date; store; payment; value), how can I search the cash value for a singular store in a specific day? Does Vlookup works? How?...

Thanks in advance.

Jorge

DateStorePaymValue      
01/janAcash57,00 € StoreA01/jan02/jan03/jan04/jan
01/janAcards60,00 € CashValue?   
01/janBcash72,00 € Cards    
01/janBcards61,00 €      
01/janCcash73,00 €      
01/janCcards53,00 €      
02/janAcash65,00 €      
02/janAcards75,00 €      
02/janBcash55,00 €      
02/janBcards87,00 €      
02/janCcash75,00 €      
02/janCcards62,00 €      
2 Replies

@jlopes65 

try SUMIFS

Hi!
I tried and in a first approach I think it will work!
Thanks a lot! Indeed!
Bye.
Jorge