Preparing of Phone Directory
Create a new workbook, consisting of 2 worksheets.
In Sheet2, create a list of contact names with tel numbers.
You could use Col A for names, Col B for Tel numbers, Col C for Cell
numbers, and maybe Col D for Fax numbers. You can extend this to also
include email addresses, postal and residential addresses, depending on your
needs. Name this tabe Details.
In sheet1, say in Col A6, enter "Contact Name"
In A7, enter "Tel Number"
In A8, enter "Cell Number"
In A9, enter "Fax Number", and so on
In B7, enter =IF(ISERROR(VLOOKUP(A6,Details,1,FALSE)),"No Records
found",VLOOKUP(A6,Details,2,FALSE))
In B8 enter
=IF(ISERROR(VLOOKUP(A6,Details,1,FALSE)),"",VLOOKU P(A6,Details,3,FALSE))
In B8 enter
=IF(ISERROR(VLOOKUP(A6,Details,1,FALSE)),"",VLOOKU P(A6,Details,4,FALSE))
--
Hth
Kassie Kasselman
Change xxx to hotmail
"isis" wrote:
Hi everybody,
Could you please help me the "arrnagement of phone guide" asap? Have you got
a ready phone directory sample? I'm using Office 2003. I'm waiting your good
news. Regards,
|