autofill or auto reference

stephen · Jul 17, 2008

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 · Jul 17, 2008

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 · Jul 17, 2008

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

autofill or auto reference

stephen

Mike H

Gord Dibben