I am having a problem regarding excel,I want to get the (network name) base on the network prefix of the (phone number) column using the value of the third column which is the (network)
Phone Number | Network Name | Network Prefix | Network Name
9162123212 ???? 0813 Smart
0910212232 ???? 0817 Globe
thanks for any help.