stuck searching

[DippNCope]

I need some help in searching.
I have a list of software in Column C and a list of install paths in Column D . Both are in named ranges, softwarelist and installpaths.
I want to enter Adobe in B1 and have formula return every instance of adobe it finds in softwarelist or C:C and return it's value and the corresponding installpaths or D:D

So if it finds adobe reader and adobe pro it should return both
This works but only returns the first instance

=IF(ISNA(INDEX(Installpaths,MATCH(B1&"*",softwarelist,0))),"",INDEX(Installpaths,MATCH(B1&"*",softwarelist,0)))

Can someone point me in the right direction please.

 

[Marcelo Branco]

Try

Array formula in B2 copied down
=IFERROR(INDEX(Installpaths,SMALL(IF(ISNUMBER(SEARCH(B$1,softwarelist)),ROW(Installpaths)-MIN(ROW(Installpaths))+1),ROWS(B$2:B2))),"")
confirmed with Ctrl+Shift+Enter, not just Enter

Hope this helps

M.

 

[DippNCope]

Thank you, it now does what I need.

 

[Marcelo Branco]

You're welcome. Thanks for the feedback.

M.