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!
TIA