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?