Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Can my drop down list (validation) populate adjacent column?

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
Hi all,

Basically I am trying to create a drop down list that then when an item in the list is selected the adjacent cell is populated by a value associated to the item selected.

For example,

I have a list of people in one column and their ages in the next column to the right:

John 12
Ian 15
Craig 20
Sam 17

Then on a separate sheet I create two cells one above the other that allow me to select a person from the list in each of the cells, what I would like is for the cells to the right of these "list selection" cells to be populated with their ages so that I can then do a "Sum" of what the total age of the people I have selected is.

Any ideas, responses gratefully accepted!

  • 0




    Tech Staff

  • Technician
  • 1,323 posts
Hello minimania :welcome:

I was able to come up with what you want. The instructions are for your list in cells A1:B4 on Sheet1. On Sheet2, create a dropdown "list selection" cell with the following for the List Source:

After that, on the column to the right, use the following formula:

Where A1 is the "list selection" cell. This is basically telling Excel to look up the value in A1, in the Sheet1!A:B range, and return the second column value from the matching row (which is the age of the selected person).


  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP