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