SOLVED

@Riny_van_Eekelen (sheet of concern)

%3CLINGO-SUB%20id%3D%22lingo-sub-2429287%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20(sheet%20of%20concern)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2429287%22%20slang%3D%22en-US%22%3E%3CP%3EDear%3A%20Riny_Van_Eekelen%3C%2FP%3E%3CP%3Ewelcome%20again%2C%20kindly%20find%20sheet%20we%20talking%20about%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20Warm%20Regards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2429287%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-2429393%22%20slang%3D%22en-US%22%3ERe%3A%20%3Ca%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%3E%40Riny_van_Eekelen%3C%2Fa%3E%20(sheet%20of%20concern)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2429393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072676%22%20target%3D%22_blank%22%3E%40Abdul-Rahman%3C%2FA%3E%26nbsp%3BDepending%20on%20your%20Excel%20version%2C%20you%20could%20use%20FILTER%2C%20XLOOKUP%2C%20VLOOKUP%20or%20a%20combination%20of%20INDEX%20and%20MATCH.%20When%20I%20did%20that%2C%20I%20noticed%20you%20have%20quite%20a%20few%20duplicated%20entries%20in%20the%20master%20list.%20For%20example%2C%20customer%20511114%20(one%20of%20your%20selected%20customers)%20has%20two%20entries%20in%20the%20larger%20table.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-06-09%20at%2006.12.24.png%22%20style%3D%22width%3A%20939px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287364i9D06CFE50BE04A6F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-06-09%20at%2006.12.24.png%22%20alt%3D%22Screenshot%202021-06-09%20at%2006.12.24.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESo%20I%20guess%20you%20want%20to%20see%20all%20transactions%20for%20all%20selected%20customers.%20Then%20Power%20Query%20is%20probably%20the%20easiest%20way%20out.%20Please%20confirm%20what%20you%20need%2Fwant.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Dear: Riny_Van_Eekelen

welcome again, kindly find sheet we talking about,

 

Thanks and Warm Regards.

 

@Riny_van_Eekelen 

2 Replies
best response confirmed by Abdul-Rahman (New Contributor)
Solution

@Abdul-Rahman Depending on your Excel version, you could use FILTER, XLOOKUP, VLOOKUP or a combination of INDEX and MATCH. When I did that, I noticed you have quite a few duplicated entries in the master list. For example, customer 511114 (one of your selected customers) has two entries in the larger table.

Screenshot 2021-06-09 at 06.12.24.png

So I guess you want to see all transactions for all selected customers. Then Power Query is probably the easiest way out. Please confirm what you need/want.


OK i will try
Thank you V.much Riny.