need help sorting mobile numbers by carrier

[mukhtar01]

I have an excel sheet named Data containing mobile number in cell C2 along with other data such as name, feedback etc .in sheet 2 i have carriers mobile code. sample file is attached
i want to sort the numbers by specific carrier example: If i select ufone all data with code 9233 is displayed (92 is the country code)
I will highly appreciate any help, which formula to use VLOOKUP or MATCH or any other

[Pete_UK]

Put this formula in E2 or your Data sheet (for example, as the column is not being used):

=IFERROR(INDEX(Sheet2!A:A,MATCH(--LEFT(Data!C2,4),Sheet2!B:B,0)),"")

Then copy it down. It will return the carrier name, so you could then filter on that column to do further analysis.

Hope this helps.

Pete

[mukhtar01]

Thankyou it helped alot