The orange table is just a list of customer and the drop down beneath it contains the name of the customers linked by using Vlookup
I want the parts of the black table to be filtered according to the client in dropdown. Keep in mind that an item can be bought by many clients so i cant use filtering in clients and add it as a last column.