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
Try it like this
=INDEX($B$5:$B$18,SMALL(IF($A$5:$A$18=$A$2,ROW($A$5:$A$18)-ROW($A$5)+1),ROWS(A$5:A5)))
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Perhaps with:
This will get rid of the repeating names and show only the uniques that match.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thank you so much! This worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks