Searching another page and pulling data over

hard to say for sure though without seeing what you have

Let me try to explain better.


I have two sheets in this excel file. Sheet 1 looks like this:

Column A
Participant A
Participant B
...
Participant S



Column B
Output from a series of equations elsewhere on the page for A
Output from a series of equations elsewhere on the page for B
...
Output from a series of equations elsewhere on the page for S


On sheet #2, I have a section where I want to select which participant I am referring to and have the Number from Column B on Sheet 1 appear next to it. So it would look like:


Column A
Participant E
Participant G


Column B
Output from Colum B on sheet 1 for Participant E
Output from Column B on sheet 1 for Participant G




Since I don't want to keep going back and forth from the two sheets.














Is there a way to maybe make Sheet 2 have a dropdown menu under column A - with all participants from Sheet 1 as options - and make it where when I select one, Column B automatically updates with the correct output for the corresponding participant from Sheet 1?