I have been trying to find a way to return a name when a row of data contains a "(".
Have been succesful when I only have one column of data, in this example, column C. Once I move beyond this, I can't resolve. The attached shows what I want returned, after a search of the Data set has been performed.
In relation to my initial post, please see the attached where I have been able to return a vlaue under the 'Name' column for rows that contained a "(". The blue column tests for a "(" in the yellow data set area. The green column performs the lookup to return a "Name" label for cells that contained a "(".
How do I extend this to perform search across multiple columns as per my original post?