Forum Discussion
Table Array Lookup
Hi, 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...
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?