Moh, Gord and Dave has definitely pointed you in the right direction - a cell
on the first sheet with Data Validation set up to point to the list of names
on the second sheet as its data source, then a cell with a VLOOKUP() into the
whole table on the second sheet to find the phone number for the person whose
name you choose in the first cell.

Easiest way to set up the data validation is to refer to the list of names
on the 2nd sheet as a named range. I'm sending you a quick down-and-dirty
setup with graphics and detailed instructions on how that's done. Probably
much like what is on Dave's site, but perhaps having it in hand will help you
understand and set your workbook up the way you need to.

You won't be able to edit the phone number that appears - that would destroy
the VLOOKUP() formula in it. But there are ways to work around that using a
short VBA routine triggered by making a selection change in the cell with the
names listed in it.

"Moh" wrote:

p.s my e-mail address is:

thank you