Phone bill nightmare

  • Thread starter Thread starter NickC
  • Start date Start date
N

NickC

I am using Office 2003

I have a telephone bill which contains about 500 different calls with the
numbers listed and amount charged. I have copied the relevant columns to a
worksheet (Call it Worksheet X)

A B C D
date phone # $ amount person responsible
there are about 500 rows

A, B, C, I took from phone bill and sorted the numbers in column B. In
Column D I would like to add the name of the person responsible for making
the call. Now I have a list of numbers that these people called with their
names (Call it Worksheet Y)

G H
phone number name
there are about 4 different names, each name has about 5 numbers (Varies)
that belong to them. So there are about 30 rows. The numbers in column G
are sorted.

What I would like to do is use the information from sheet Y to fill in the
name in column D of sheet X, automatically.

I need to do this so that each person could be billed for the calls they
made

Please help.
 
In Sheet: X

Put in D2:
=INDEX(Y!H:H,MATCH(B2,Y!G:G,0))
Copy D2 down

Alternatively, perhaps better but slightly longer with error-trapping,
we could put instead in D2:

=IF(B2="","",IF(ISNA(MATCH(B2,Y!G:G,0)),"Unmatched
phone#",INDEX(Y!H:H,MATCH(B2,Y!G:G,0))))

Copy D2 down as before
 
Thanks Max:
It worked. Now I am trying to understand the formula and its application.
Thanks again
 
Back
Top