I'll try to explain this. hopefully the attachment below will help. I am trying to create a list of all instances where contents in A3 is found in C5:C12 and return the values in D5:D12 without any spaces. Right now I can do it in two steps but I'd like to clean it up and do it with only one formula. Any takers??
Bookmarks