Hello guys,

I have a list of UK mobile phone numbers which all start with 07. I have another list of UK mobile operator codes (e.g 07495 numbers are the mobile operator EE).

I used a Left formula (=Left(a1), 5) to extract the first 5 numbers of my list of numbers and then did a Vlookup to assign the carrier name to each operators dial code in a separate column. However, I got quite a few "N/A"s. I then noticed that some of the carriers have 6 number dial codes (e.g. 074482 )

Is there a way of saying if this mobile numbers starts with the either the 5 or 6 numbers in my list, then it is X operator please?

Thanks for any advice offered.