for example Coffin (a1,1) Lewis(b1,1) and i have coffin.lewis (a1,2) metering tech (b1,2) i want to return in (c1,1) metering tech and then expand formula down so that it works for all ? all in (a,2) follow coffin.lewis for first and last name however (a,1) and (b,1) may contain middle names or jnr / snr eg Coffin Jnr (a1,1) Lewis (b1,1) or Coffin (a1,1) James William Garcia (b1,1)

might be a bit confusing new to forum and bad at describing things

thanks

lewis