@Riny_van_Eekelen (sheet of concern)

New Contributor

Dear: Riny_Van_Eekelen

welcome again, kindly find sheet we talking about,


Thanks and Warm Regards.



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

@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.