View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
kassie kassie is offline
external usenet poster
 
Posts: 515
Default 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,