Hello happy_smiler1
You should be able to do this with an array formula like this:
{=IFERROR(INDEX(B$19:B$99,SMALL(IF($B$19:$B$99=$J$18,ROW(B$19:B$99)-18),ROW(B1))),"")}
In case your not familiar with these, you tell Excel by pressing Ctrl+Shift+Enter when you have completed it. Excel then places braces around the formula to indicate its array status.
You cannot type in the braces and they are removed if you edit the formula, so you need to press C+S + Enter again after you have edited.
In this case what you get something like a database search, that can find every instance of a search value you specify in a separate table and return other details from the matching entry.
It can work with a drop down list (in cell J18) as in my example.
HTH
Hercules
Bookmarks