Excel telephone contact template

But, if you are wondering how to set up a sortable 2-column list in Excel, download the phone directory template and continue reading below to learn how it was made. License : Private Use not for distribution or resale. This template demonstrates how to create a 2-column list that uses Excel formulas to reference a data source.

I created this template to answer a question posed to me by Jonathan Weinraub about how to make a sortable 2-column phone directory. The problems were how to make the directory update automatically when the data source was sorted, and how to prevent REF! Our data source is a separate worksheet with an Excel Table consisting of names, phone numbers, and other contact information created using the Contact List Template.

This is a special feature in Excel that allows you to use structured refences. The Directory worksheet will be used for printing the multiple-column phone list, so create it using whatever formatting, fonts and colors you want. As demonstrated in the phone list template, I have 2 separate groups of columns labeled , Name, Phone. The column is critical - it will be used to reference the corresponding row from the Data worksheet.

Whether trying to keep track of all your contacts or putting together a phone or address list for a specific occasion, Vertex42's free customizable Contact List Template can help you get organized. Great for clubs, organizations, families or your own personal needs, the Contact List Template will help you get off to a quick start. The template allows you to easily sort and filter by any heading, and it is ready for printing. But since the criterion is non-constant, and we will constantly change the last name to find out phone numbers of people, we have additionally used the «MATCH» function.

It helps to find the position of the desired row and column. Working with lists in Excel implies a comparison: comparing data, finding the same or unique items. Let's try for example to compare two simple lists. There is information on the two warehouses. Our task: to check up, what positions are missing on both warehouses to make in the future the order and deliver the missing products.

Highlight both lists without headers using the CTRL key. We don't need the space between the lists i. A small window will appear where you can choose to command showed duplicate or unique values.

Choose «Unique». Here are a few items you may include on an emergency contact information form:. Primary and Secondary Contacts: Employees are often asked to list more than one emergency contact and to name the relationship to each person. This could be a relative, friend, or other contact who is accessible with a current phone number.

Emergency Services: Calling is often the first course of action, depending on the emergency, but it can also be helpful to include contact information for the police, the fire department, and other services. Medical Conditions: Employees may choose to list medications or other medical information, such as doctors or existing health conditions, in case an emergency takes place at work and they are in need of medical care but unable to communicate in the moment.

Services for Minor Emergencies: Having easy access to phone numbers for a taxi, locksmith, or other service can expedite dealing with minor events.

Emergency contact lists are important not only in a business setting, but also at school and at home. In the home, this type of list is especially helpful for keeping babysitters and other caregivers in the loop, maintaining neighborhood contacts, and more.

The more prepared you are, the more likely that you will handle an emergency smoothly. Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change.

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done.

Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. Try Smartsheet for free, today. In This Article. See how Smartsheet can help you be more effective. Managing Business, Employee, and Emergency Contacts Businesses may require multiple databases for tracking customers, vendors, and other contacts.