match function on a filtered list

[BORUCH]

HI

i would like to use the match function on a filtered list

it should return n/a if it doesn't exits on other list how can i do that ?

 

[DanteAmor]

Check the following solutions

https://www.mrexcel.com/forum/excel-questions/1032066-sumproduct-subtotal-filter.html

https://www.mrexcel.com/forum/excel-questions/1067666-filtered-countif-subtotal.html

https://www.mrexcel.com/forum/excel...ing-index-offset-functions-filtered-list.html

https://www.mrexcel.com/forum/excel-questions/768085-subtotal-unique-values-when-filtering-list.html

https://www.mrexcel.com/forum/excel-questions/116062-match-index-offset-subtotal.html