Searching another page and pulling data over

**undergrad055** · 10-13-2012, 06:23 PM

It might sound a bit complicated,and I'm not sure if this is the right place, but here goes:

I've got one page with a list of participants and data I've done work with to get an output.

I am wondering if there is a way to set it up where I can be on a different page and have it where I select which participant I am referring to and have it automatically pull the output from the other page right next to it. So where it would be like:

Participant cell (choosing between A-Z)
Output from 2nd page associated with whichever A-Z I choose

Is this possible?

**FDibbins** · 10-13-2012, 06:29 PM

sounds like vlookup or index/match will work here...hard to say for sure though without seeing what you have
To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**undergrad055** · 10-13-2012, 07:19 PM

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?

**FDibbins** · 10-13-2012, 07:24 PM

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**undergrad055** · 10-13-2012, 08:00 PM

As of now, I've figured out how to do it for exactly Participant A with the following formula:

=(IF(I18="A",'Sheet1'!C24))

Then if I'm putting "A" in the I column, the next column is putting in the value correctly.

It's the next portion I'm having difficulties with. I want to make it where it goes: "If A, then pull from this Cell. If B, pull from this one. If C, pull from this one" all the way through the letter S. How would I do this?