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