Oct 25 2021 01:07 PM
Hey everybody. I am looking for the code or script to do the following:
1. We have various data lists on our computer (Excel and Google Sheets) that we'd like to match the first 6 numbers to a database that lets us know if the phone number is mobile or landline.
2. Then write the result into the data list that we have.
If anyone knows how to do this I would be very grateful, also I would not mind paying someone if you can not help us for free. Which is understandable.
Please watch this: https://www.youtube.com/watch?v=cqr59xEO70Q
Oct 25 2021 03:23 PM
If the database were in an excel sheet i would suggest formula like this:
=IF(VLOOKUP(LEFT(A2,7),CHOOSE({1,2},Tabelle1!$A$2:$A$21&" "&Tabelle1!$B$2:$B$21,Tabelle1!$H$2:$H$21),2,FALSE)=1,"landline","mobile")
In Excel 2013 formula has to be entered as arrayformula with ctrl+shift+enter. Maybe you don't have to press ctrl+shift+enter in your excel version.
Formula works if the phonenumbers have syntax like 135 919 2152. In your example there are phonenumbers like 1359192152, without spaces. This would require adaptation of the formula.
Oct 26 2021 09:15 AM