[animazn]

I'm trying to do the following:

Sheet 1:
I have a dropdown with a list of names in Column A

Sheet 2:
I have a list of Names in Column A
I have a list of Ages in Column B
These lists are dynamic and not always in the same order

I want to have Sheet 1, Column B populate the Age of whatever name is selected in the dropdown. Is this possible?

 

[etaf]

you should be able to use vlookup to do that

can you attach a sample spreadsheet with dummy data