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