John,

You could use a combo box for your phone reps to lookup the contact
name and then this formula in the cells to the right of it to populate
the corresponding contact info like Phone, Company etc...

=OFFSET(INDEX($A$5:$A$15,MATCH($A$4,$A$5:$A$15,0)),,1)

This will not take them to the point in the list where your contact
info resides but rather pull that info automatically and populate in
the same cells every time.  You need to link the combo box to A4 in my
example.  I usually then put the combo box over it so you don't see the
value twice.  Then format the combo box as MatchEntryComplete.  This
will enable users to enter in the first letter or multiple letters to
locate the contact from a drop down list.

In this example, I put Contact in A5:A15, Phone # in B5:B15 and Company
Name in C5:C15.  My combo box covers cell A4.  In B3 & C3 I put my
headers, Phone # & Company Name.  In B4 use the above and in C4

=OFFSET(INDEX($A$5:$A$15,MATCH($A$4,$A$5:$A$15,0)),,2)

I changed the 1 at the end of the formula to a 2 in order to get the
2nd column of data from the contact name match.

Does that help?

Steve