Ron
Actually it was Dave Peterson who supplied the link to Debra's VLOOKUP info.
I would have done the same thing if he had not beaten me to it.
I believe this is all Moh will need.
Gord
On Sun, 24 Sep 2006 22:02:31 -0400, Ron Rosenfeld
wrote:
On Sun, 24 Sep 2006 18:03:01 -0700, Moh wrote:
gord dibben i'm still waiting for your reply...
sorry ron rosenfeld but i don't know much about excel but i can understand.
is it possible someone can do me a quick template.
for example it needs to have a dropdown list with names in there and once
the user selects a name a telephone number will appear in a cell.
which i can then edit
thank you
--
please can you help... its urgent
Use Data Validation to set up a list; and then use VLOOKUP to get the phone
number.
The link that gord supplied, http://www.contextures.com/tiptech.html has
information under Data Validation for enabling the lists, and also information
on using VLOOKUP to get at the data.
However, if you want to possibly edit the phone number back on the original
source, by making changes where it comes up next to your cell with the dropdown
list, you will need to either write a VBA routine, or possibly you can use a
database program.
--ron