Vlookup for case with identical lookup values?

[lopata]

Hi

Til now I have found many answers here, but this time I am really stuck :/

I am trying to sort some items but many of them have the same factor. With VLOOKUP it returns only the first value, so I am using the trick with the INDEX and the SMALL formulas (I saw it in some thread here but after that I lost track of it… ), but obviously doing something wrong. Attached you could find sample table with my struggle. If there is different and easier approach leading to the desired result I will be more than happy to see it.
Any help would be highly appreciated.

PS. Sorry for breaking Rule 2, I simply thought this doesn't deserve separate thread.

[NBVC]

Try:

=INDEX($B$2:$B$10,SMALL(IF($A$2:$A$10=$E2,ROW($A$2:$A$10)-ROW($A$2)+1),COUNTIF(E$2:E2,E2)))

confirmed with CTRL+SHIFT+ENTER and copied down

[lopata]

Many, many thanks!
Have a nice day