Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
Feb 06, 2021

Excel filter when found in a second table.

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

 

 

 

Resources