How to go about creating a self populating cell.

H

Hizaed

Ok, here is my question. Say I have two columns. In the first column I enter
a persons Name, as soon as the name is entered in the first column the
person's phone number automaticly populates to the second column next to the
corresponding name. Is this possible? I know that if possible I would need a
table with all of the names and phone numbers already on it. Thank you very
much for any help that you can offer.

Hizaed
 
R

RayG

dont know a lot, there may be an easyer way.
VLOOKUP will work. Make a templet of all names, numbers, ss# any information
you may want on a templet. Then use write a VLOOKUP formula in the cell you
want to return the Phone number in. The templet sheet can be in the same
workbook or its own workbook.
Lookup value: will be the cell you will be typing the persons name
Table_array: will be the columns with the persons name and number on templet
sheet
Col Index num: will be the column number with the number entered A=1, B=2,
C=3 and so on
Range_lookup: Type in FALSE

This should work, but there may be a better way.....
 
Top