dragging

[Guest]

IN Excel, I am trying to get data when inputted into one cell, to
automatically drag over into anothercell. Example: If I enter in
Ticketmaster into cell A1, I want to be able to click and drag into cell B1
and 800-559-1212 appear. Does anyone know how to do this or what the name of
the function is called and how I can set it up?

 

[Anne Troy]

You need a VLOOKUP, Caryn. Put your name/phone number list on sheet2, and do
your lookup on Sheet1. Here's a sample file:
http://www.myexpertsonline.com/freedls/pricelist.xls
You can use a drop-down or not:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm
And here's your VLOOKUP:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com