autofill or auto reference

[stephen]

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?

 

[Mike H]

Stephen

This in b1 on sheet 2 with the name in A1
=VLOOKUP(A1,Sheet1!A1:B100,2,FALSE)

A word of caution. Unless you are very careful with data entry this is likey
to be problematic and rogue spaces are likely to be you biggest problem. For
example

Stephen surname (With one space in the middle)
Stephen surname (2 spaces) are completely different strings

Mike

 

[Gord Dibben]

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