I’m stuck in a situation where I need to be able to use VLookup to pull information based on text strings that all start with qvs. I’ve used normal concatenate across the 5 columns in question but it returns too much information and my vlookup formula errors. Is there a way to write a...
Needs help in order to match longest prefix, As an example
I have an excel which contains prefix list like below; Column A contains regions and Column B contains prefix.
Afghanistan - Mobile - Afghan Telecom 9375
Afghanistan - Mobile - Awcc 9370