Hy
As an index formula would work =Index(A1:A10,Match(C1,B1:B10,0)) this is the most basic index and match.
I need to get multiple results in the same cell divided by a comma based on a value: C1
So I created this function:
Function speciallookup(result_range As Range, lookup_range As Range...