Hi Sarabkelly. I'm assuming your address book is in Sheet 2 and your
proposal form is in Sheet 1. You can use the VLOOKUP function to populate
the address book information into your proposal. Assuming your Sheet 2
information is Column A = Company Name; Column B = Address; Column C =
Telephone, and so on. Please correct the cell references to fit you data,
but, for example, on Sheet 1, Cell A1, you could type the Company Name. Then
in A2, use the VLOOKUP function to insert this formula: VLOOKUP(A1,'Sheet
2'!$A$2:$C$100,2,FALSE). This will yield the Address, because it is in the
second column to the right in sheet 2. VLOOKUP(A1,'Sheet
2'!$A$2:$C$100,3,FALSE) would yield the Telephone Number.

Use the $'s in the formula to make your data range Absolute for ease of
copying.

A couple of important things with VLOOKUP. Put Column headings in Row 1 on
Sheet 2: Company Name, Address, Telephone, and so on. The Company Name,
because you are using it as the ID for your lookup, must be unique. Also,
sort your address book on Company Name ascending. HTH
--
Sincerely, Michael Colvin


"Sarahbkelly" wrote:

In my business- I type many proposals in a day to my customers. I have the
proposal form as well as my address book saved as Excel files. Is there a way
to link my address book to my proposal so information such as address, phone
#, and etc are automatically imput?