I have a task wherein I call certain telephone numbers on regular basis. Sometimes I call strange numbers too. The telephone is a cell mobile and all those I call often are staff members. There is a database containing the names and cell numbers of all staff members in a worksheet. The bill from the telephone company displays only phone numbers. What function in Excel can I use to detect whether a number in a bill (in another excel sheet)is found in the staff database; and then for instance do the comparism and give the results in another sheet. leaving behind only those numbers that do not exist in the staff database.
2. The column you are looking up (in this case the names) must be the right of the column containing the search criterion (phone number). If it isn't, you would need to use ine INDEX and MATCH functions.