How to use lookup formula when using slicer table

[Divemaster]

Hey i made a drawing finder with 5 tabs. Each tab has a table with slicer.

With an adittional search option via lookup.
Some items are double with different drawing numbers but not when sliced.
But it seems that lookup fuction does not take in account the slicing part. Instead it search in the complete total tabel even when it does not show on screen.

Anybody an idea how can i make this work?

 

[mart37]

Can you not use a second slicer instead of the lookup?

 

[Divemaster]

Can you not use a second slicer instead of the lookup?

Thnx thats the best solution.
Got things working