Excel filter when found in a second table.

[Geir Hogstad]

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

See eample file.

Best regards

- Geir

[#2]

@Geir Hogstad 

Yes, that's possible, will be like

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