Dropdown menu

[Hakan]

I have technical services in several cities, and several customers in those
cities. I am creatinf a book to manage this services and created an excel
book which has 3 worksheets.
1.Planning Sheet
2.List of customers
3.List of service agents
I make dropdown lists for customer and services columns on planning sheet.
The data is taken from sheet 2 and 3.
While working on planning sheet (1) , if user selects Customer1 (A1) from
drop-down list, can I import automatically his phone number into B1? This
data is already on Worksheet 2 (List of customers) This is something about
making links between cells.
Thanks a lot

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Debra Dalgleish]

You can use a Vlookup formula in cell B1, to return the matching phone
number. There are instructions in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html

 

[Fred]

Send me an email at (e-mail address removed) and I will forward a file.