LaughingBear
New Member
- Joined
- Aug 10, 2010
- Messages
- 3
We have a DO NOT CALL list - where each phone number is stored in a separate row in 3 columns. Example phone number 303-408-5566 would be stored in 1 row Column 1 303, Column 2 408, Column 3 5566. I need to be able to look up a phone number to see if it is on the DO NOT CALL list. The find feature only works on one Column and its only a combination of the 3 columns that makes a unique result. So far I have been using the "find" feature and the 3rd column and four numbers - example "find" 5566 the problem is I still get all numbers for every area code and pefix that meet that criteris. I want to be able to look up the full phone number across 3 columns of data per row