Jun 08 2021 08:09 PM
Dear: Riny_Van_Eekelen
welcome again, kindly find sheet we talking about,
Thanks and Warm Regards.
Jun 08 2021 09:19 PM
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.
Jun 08 2021 09:19 PM
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.