Looking for PART of a cell, in another column and return corresponding value

Hi AdiKerr

Don't think there's an easy way to get around this, as you are trying to match up "things that don't match" ! What happens when there are multiple "plusnet" matches in your sheet 'DATA'? Or are there no duplications of that name?

Pete