URGENT: I am looking for the code or script to read a database...

New Contributor

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

2 Replies

@Vision1291 

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.

Hey QP, thank you for the comment. Would you be interested in working with me direct to help me figure this out. I am happy to pay you.