auto populate cell based on previous cell drop down list selectio.
 

I am trying to auto populate data in a cell based on the selection in the
previous column. I have created two lists - one with the name and one with a
number that is associated with that name. In my data entry fields, I would
like to be able to select the name from the "name list" (I have done this
already), but then I would like the number data entry field to auto populate
to the number associated with the name in the lists that I have created. Any
help would be greatly appreciated

auto populate cell based on previous cell drop down list selectio.
 

Use a VLOOKUP / HLOOKUP formula that takes the value given by the dropdown
list and uses it to lookup for the other value....


"PuzzledbyLists" wrote:

I am trying to auto populate data in a cell based on the selection in the
previous column. I have created two lists - one with the name and one with a
number that is associated with that name. In my data entry fields, I would
like to be able to select the name from the "name list" (I have done this
already), but then I would like the number data entry field to auto populate
to the number associated with the name in the lists that I have created. Any
help would be greatly appreciated

auto populate cell based on previous cell drop down list selectio.
 

There are instructions here for VLookup:

http://www.contextures.com/xlFunctions02.html

And a sample order form that uses VLookup formulas to complete customer
information:

http://www.contextures.com/xlOrderForm01.html

PuzzledbyLists wrote:
I am trying to auto populate data in a cell based on the selection in the
previous column. I have created two lists - one with the name and one with a
number that is associated with that name. In my data entry fields, I would
like to be able to select the name from the "name list" (I have done this
already), but then I would like the number data entry field to auto populate
to the number associated with the name in the lists that I have created. Any
help would be greatly appreciated


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html