How can I populate an Excel cell based on the data in another cell

G

Guest

I am hoping someone can help me with this.

I used the Data>Validation>List function in a particular cell in my
spreadsheet.
Once that cell returns a particular entry, I want an adjacent cell to
populate with the corresponding number.

For example. I have a "drop down box" in cell G11. I click on the drop down
box and choose option WM6023. Once I have chosen that I want the adjacent
cell (H11) to recognize that entry and populate with the number 709. i.e.
the number 709 will always be associated with "WM6023" and will automatically
populate in cell H11 when "WM6023" is chosen from the "dropdown box" in G11.
It also follows that If I choose another entry from the "dropdown box" in
G11 a different cooresponding number will appear in H11.

Any ideas?
 
G

Guest

Hi,

Prepare a table in a different range where the first column of the table has
these codes and the second column has the corresponding number.

Now in the G11, use the vlookup formula to obtain the corresponding number
from the secong column of the table you inputed. Vlookup is well explained
in the help menu

Regards,
 
R

Rowan Drummond

Use a Vlookup formula in cell H11.

You will need to set up a lookup table but if your data validation is
using a list from a spreadsheet then you are already half way there.
Next to your list of codes that appear in the dropdown enter the number
you want to appear in H11 associated with each code.

Say this table is in range A1:A10.
In H11 enter the formula
=vlookup(G11,A1:A10,1,0)

For more detail on vlookups see excel help and
http://www.contextures.com/xlFunctions02.html

Hope this helps
Rowan
 

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 to populate a cell with numeric value based on textselected from pull down in adjacent cell? 1
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
Drop down box issue 2
Conditional Formating based on Data Validation 3
How do I Keep a Combo Box "Focused" on difrferent cells. 5
Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
One validation drop-down populates another? 1
Populate cell with data from another worksheet 4

Top