Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell value dependent on another cell entry
Afternoon all
Having a senior moment in need of help. I have created a list of names using data validation that works fine what I need to do next is once a name is chosen automatically have their phone number appear in the next cell. I am sure its possible so if you have any ideas they would be much appreciated. TIA Ajay |
#2
|
|||
|
|||
I assume you have a table with names and telephone numbers
in the cell where you want the number to appear try =vlookup(name,Name-number-range,2,False) Assuming the number is next to the name. In not the 2 needs to be adjusted. "Ajay" wrote: Afternoon all Having a senior moment in need of help. I have created a list of names using data validation that works fine what I need to do next is once a name is chosen automatically have their phone number appear in the next cell. I am sure its possible so if you have any ideas they would be much appreciated. TIA Ajay |
#3
|
|||
|
|||
I'd put the phone numbers in the column to the right of the list of names.
Then you could use an =vlookup() formula to return what you want. Say your data|validation cell is A1. Your list of names/phone numbers is in sheet2!a1:B99. Then you could use: =if(a1="","",vlookup(a1,sheet2!$a$1:$b$99,2,false) ) Visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. Ajay wrote: Afternoon all Having a senior moment in need of help. I have created a list of names using data validation that works fine what I need to do next is once a name is chosen automatically have their phone number appear in the next cell. I am sure its possible so if you have any ideas they would be much appreciated. TIA Ajay -- Dave Peterson |
#4
|
|||
|
|||
Just the job Excellent!
many thanks bj and Dave Ajay "Dave Peterson" wrote: I'd put the phone numbers in the column to the right of the list of names. Then you could use an =vlookup() formula to return what you want. Say your data|validation cell is A1. Your list of names/phone numbers is in sheet2!a1:B99. Then you could use: =if(a1="","",vlookup(a1,sheet2!$a$1:$b$99,2,false) ) Visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. Ajay wrote: Afternoon all Having a senior moment in need of help. I have created a list of names using data validation that works fine what I need to do next is once a name is chosen automatically have their phone number appear in the next cell. I am sure its possible so if you have any ideas they would be much appreciated. TIA Ajay -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a ComboBox for Data Entry into a Cell | Excel Worksheet Functions | |||
Manual or Formula entry in cell. | Excel Discussion (Misc queries) | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
Formula based on a cell entry | Excel Discussion (Misc queries) | |||
resolving a numeric cell entry for its meaning | Excel Worksheet Functions |