How to output values ​​from an array of strings other than those specified in another array of strings in Google Sheets?

Question

Google Apps Script

There is the first list of lines with data - all names of goods.
There is a second list of lines with data - a part of the goods from the first list, selected according to certain criteria.
It is necessary to use a formula to display the third list, which excludes the names of the second list from the first list and displays the remaining products.
How to make it a formula?
https://docs.google.com/spreadsheets/d/1-Xr3CCSNyu...
Rows of the first list (complete) in column F
Rows of the second list (to be removed from the first one) in column K

Thank you!

Answer 1

Try

=FILTER('Лист1'!F:F;ISNA(MATCH('Лист1'!F:F;'Лист1'!K:K;0)))

More examples https://docs.google.com/spreadsheets/d/17mpcNilHA4...