@Riny_van_Eekelen (sheet of concern)

[Abdul-Rahman]

Dear: Riny_Van_Eekelen

welcome again, kindly find sheet we talking about,

Thanks and Warm Regards.

@Riny_van_Eekelen 

[#2 · Accepted 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.

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.

[#3]

OK i will try
Thank you V.much Riny.