• Answers
  • Web
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.

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:


Q:

Reverse phone look up to trace a phone call?

How can I perform a free reverse phone look up to trace a phone call? All the websites that advertise "free reverse phone look up ...
Submitted by Firstday   5 months ago.
  • viewed 1288 times
Last answer posted 12 days ago by mick


Q:

Free reverse cell phone look up, reverse cell phone directory?

Free reverse cell phone look up, reverse cell phone directory Is it possible to perform a free reverse cell phone number lookup ...
Submitted by estella   4 months ago.
  • viewed 783 times
Last answer posted 12 days ago by jane



» More...

Explore Related Posts in Forums

"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 with the complexities of spreadsheets but I dont think it can do this: - Quote: from: tomos on November 05

First Usable Spreadsheet comes to Cell Phones

spreadsheets on your iPhone, this is the app to get. Read, write, and edit Excel spreadsheets - Microsoft spreadsheet application would be able to read, write, and edit Excel spreadsheets. I'm glad to say . This displays the Files screen, which lists all of the spreadsheet files that are currently stored

PointUI for all Touch Screen Phone Owners for FREE

Smart Lists Navigation with bookmarks allows you to easily locate an item in even the largest lists emails, text messages, multimedia messages, tasks, appointments, documents and spreadsheets * Load Hey ya all, if you own a Touch Screen Mobile phone and supports Windows Mobile > 2003 >, then this software is for ...
» More...
Powered by
Feed - Subscribe to changes to this Q&A Blog
ADVERTISEMENT
  • Answers
  • Web
Copyright © 2006-2009, Yedda Inc. and respective copyright owners · CC License