Excel filter when found in a second table.

Frequent Contributor

Hi,

 

Is it possible to filter from a table, when the value is in a second dynamic list?

 

=FILTER(Tabell2[Name];Tabell2[Name]=K3#) Return #IT

=FILTER(Tabell2[Name];Tabell2[Name]=K3) Return the first valu in the dynamic list

 

filter dynamic list.PNG

 

See eample file.

 

Best regards

- Geir

 

 

 

1 Reply

@Geir Hogstad 

Yes, that's possible, will be like

=FILTER(Tabell2,COUNTIF(L3#,Tabell2[Name]))