Hello there,

I know my way around excel more or less.
I have made a table of all parts we sell in the company. It uses many items and has many columns and rows (price size etc...).
I used filters in the table so as to remove the parts we dont need and leave the parts we need according to the client.
I have made another table with all the clients we have. I made a drop down list that points to each client.

let's say client 1 buys items 3 5 and 6.
client 2 buys items 37 43 and 67.
client 3 buys items 7 55 and 91.

How do i make the drop down list point to the list of items of the client?
For example when i choose client 1 in drop down list, i want items 3 5 and 6 to be ticked in the filter only. (I want it saved as template to re-use for all clients).
I thought about using =nameofclientindropdownlist in the last column of the filtered table, but the value only shows 0. Apparently formulas dont work on filtered cells. If the formula had worked, then it would only tick the client in the formula (thats what i was trying to do)

Thanks!