Originated from
AOL Search

I have a phone list in a works spreadsheet, I have ...

I have a phone list in a works spreadsheet, I have started a phone log to keep track of calls made and by whom.  I want to write a function that will insert the persons name automatically when the corresponding phone # is typed in.  Can some please help me?


Share Send to a friend Watch Report
 
 

Posted Answers

 

You'll need a sheet with customer details in with the phone number as the first column.  On the tracking sheet you can make the name field into a vlookup so that it returns the name once the phone number has been entered.  Rather than typing in the numbers on the tracking sheet all the time, you would probably be better off using Data validation to give you a drop down of all the numbers you have to choose from.  Then it would just be a case of scrolling down the list to find the number and once selected the name would appear as well.


Posted 1 month ago ( permalink )
In reply to Triedall's question
Rated as
#1 out of 1
0
0

Helpful?

line
line
line



Sign in to participate

Got an answer for Triedall? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Sign up for a free account, or sign in (if you're already a member).

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Tabs in MS Excel

Is there a way to display multiple tabs in MS Excel over two or more rows? I have many tabs and switching between them, while not ...
Submitted by drabsv 2 years ago
  • viewed 1120 times

Last answer posted 2 years ago by EscApe


The best office suite

Which one would you recommend as the best office suite - OpenOffice, MS Office 2007 or some other? Please share your comments. Do ...
Submitted by drabsv 2 years ago
  • viewed 974 times

Last answer posted 2 years ago by drabsv


Explore Related Posts in Forums

Excel Spreadsheets on Companyweb

Not a problem, just a shout... I would like to place a dynamic excel spreadsheet of sales persons Import Spreadsheet under Custom Lists. 2. Specify a name and then click Browse...

"To-Do-Visual" or "Multi-Lists" - does this exist?!

Forster follower) It may well exist - I mean as software. First: My problem with To-Do-Lists things get lost in tree-lists, "flat" lists are too long, tagging just doesnt cut it for me

Is there pseudocode for UK address or phone number validation? Overflow

I only know the ones in the USA right now. Address Line 1 Phone Number Mobile Number (in case which lists valid addresses)Perl has the Number::Phone module that can handle...
» More...
Powered by
Feed - Subscribe to changes to this Q&A Blog
Copyright © 2006-2008, Yedda Inc. and respective copyright owners · CC License