MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Phone Number matching


Posted by Saunders on April 29, 2001 7:25 AM


OK I hope someone can help me with this problem,
I have a list of over 800 phone numbers along with data beside the number (this data is just how many calls came in on the line ect. really not important to my question)...

I need a way to grab data based on the number searched for...

for example I have the number I want to find
5066961515 and the number I'm searching for appears the same way in the list. when it finds the number in the list display info from B***

Can anyone help, it can't be that complicated


Posted by Saunders on April 29, 2001 8:21 AM

I found the answer to my question... its one of the tips on the site the link to it is


http://www.mrexcel.com/tip021.shtml