Phone book problem

[Guest]

I manage the phone bills for the company I work for. Each month I get the
phone bills emailed to me in excel format and I have to manually check the
phone numbers against a list of company numbers I have to ensure staff are
not mis using the phones. Is there any way that I could get excel, if I had a
list of phone numbers and names already typed up to match numbers on the
bills I get to the list I have typed up and have it place the name of the
person after the number so at a glace I could match each bill and see who has
been rang in the company or not for that matter Any help greatly appreciated.

 

[Guest]

Take a look at VLOOKUP() - it should solve your match up problems.

Basically, bring your monthly report data into a worksheet in the workbook
with your master list (separate sheet) and set up a VLOOKUP() formula to
bring name into the monthly list sheet.

Since you'll be matching on the phone numbers, first thing is that the
numbers must be entered in the same format in both lists (so make your master
list match format of your monthly lists).

Second, in the master list, the phone numbers need to be in the left-most
column of a table (it could be A, or it could be X, but names need to be in a
column to the right of it).

Assume phone numbers in Master list are in column A, names in column B.
Assume phone numbers in the monthly data are in column D, then on a row
(using row 2 for example) in the monthly data sheet you could put a formula
like
=VLOOKUP(D2,'MasterListSheet Name'!A:B,2,0)

That would return names, but it also returns an ugly #NA when there is no
match for the number on the monthly sheet with a number in the MasterList,
you can modify the formula to keep the sheet cleaner like this:
=IF(ISNA(VLOOKUP(D2,'MasterListSheet Name'!A:B,2,False)), "",
VLOOKUP(D2,'MasterListSheet Name'!A:B,2,False))

Excel Help will give you information about the VLOOKUP() function.

 

[Guest]

Thank you so, so much. That worked brilliantly. I very much appreciate you
help and time. Thanks again.

 

[Guest]

You are very welcome. Glad I could be of assistance to you.

And thank you for the thank you and letting us know that it worked for you.