VLOOKUP formula is one method.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for inputting
the data if need be.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 09:10:02 -0700, stephen
wrote:

I have a list on sheet 1 a1-a100 with names of clients in it. Same sheet,
column B1-B100 i have the phone number.

If in sheet 2, i put the name of the client in one cell, is there a way i
can get the phone number to auto fill in on the next cell in the same sheet?