LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
muskiediver
 
Posts: n/a
Default using vlookup to find phone numbers online


How can I create a vlookup function to automatically retrieve phone
numbers off switchboard.com using my current mailing list?

I have a list of more than 4,000 of my customers. I want to ad in
phone numbers automatically. I currently have the first and last name
in one column. The address, city, state and zip are all each in their
own column.

I have never use vlookup before, nor have I ever used excel other than
for data entry. What is the easiest and most efficient way to do
this?

I searched this site and seen vlookup mentioned for this type of
automatic data entry. There may be another way or method I am not
aware of. If so please advise.

Thank you.




I am using Microsfot Excel 2002 on Windows XP.


--
muskiediver
------------------------------------------------------------------------
muskiediver's Profile: http://www.excelforum.com/member.php...o&userid=33384
View this thread: http://www.excelforum.com/showthread...hreadid=532113

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find sum in list of of numbers Jim Thomlinson Excel Worksheet Functions 3 January 4th 06 09:58 PM
find sum in list of of numbers Jim Thomlinson Excel Discussion (Misc queries) 5 January 4th 06 07:07 PM
'find' somtimes can't find numbers. I folowd the 'help' instructi. Yaron Excel Worksheet Functions 2 November 30th 05 05:46 PM
Vlookup to find Second INstance [email protected] Excel Worksheet Functions 1 September 16th 05 03:33 AM
Find Median of Positive numbers only in Range MichaelC Excel Worksheet Functions 4 June 24th 05 03:06 AM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"