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...