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

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I auto populate based on a drop down list? 0
Auto populate cell 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Using a drop-down list along with an auto-populate drop-down 1
Auto Populate Based on Other Selection 2
Populating other cells based on a choice from a drop-down list 1
Best method to populate cell based upon drop down list selection 4
Populate cell with data from another worksheet 4

Top