Excel filter when found in a second table.

Regular Contributor



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