Hello!

I have a bit trouble with my INDEX formula. So I have in columm A many products and in columm B many company names, I need to see company name for a defined product. The problem is that the products and company names repeats a lot.

I tried this formula =INDEX($A$5:$B$18,SMALL(IF($A$5:$A$18=$A$2,ROW($A$5:$A$18)),ROW(1:1))-1,2) but it doesn't seems correct.

Could somebody please advise me how I can solve this?

I have attached my excel example.


Any help would be appreciated.Book1.xlsx