Linking Data

[Violeta]

I have data in several worksheets.

Each worksheet corresponds to a school, for example, Peoria High School.
Every worksheet has three columns: Student ID, Date, Duration.
Then I have one large worksheet with ALL sudent ID's and Reading Scores.

What I need to do is find all the reading scores for students at individual schools. So the common column between all worksheets is the Sudent ID.

How do I find the reading scores of students with particular Student ID's in the school worksheets from the main worksheet of all student ID's and reading scores?

Thank you!

[corinereyes]

Hello,

Can you attach a sample file so its easier to place formulas?

[Violeta]

Worksheet one
StudentID LoggedOnDate Duration
123456789 24/04/2007 0:10:51
234567890 01/05/2007 0:14:27
345678901 09/04/2007 0:29:23
456789012 24/04/2007 0:4:54

Worksheet two
StidentID ReadingScore
123456789 339
234567890 350
345678901 338
456789012 380

I couldn't attach an excel file; it wouldn't let me. The Student ID, LoggedOnDate, Duration, StudentID, ReadingScore are all individual columns with those column headers. Above is worksheet one and worksheet two. Worksheet two has a LOT more student ID's, all schools and all grades!

But worksheet one has student ID's only for a particular school, and I need to grab THOSE students' reading scores from Worksheet two, but I need a way to match them up!

Thank you!

[Violeta]

Please, can anyone help with this?
My boss wants this data today and I have no clue how to get it.
Thanks!

[libre4vida]

This sounds like something the vlookup function may be able to help you with. Here is a How-to that may be able to help you.

http://www.timeatlas.com/mos/5_Minut...OKUP_in_Excel/

[Violeta]

Not sure which one of those applies... I might have to look all of these up by hand! Ugh!

[Dean England]

Violeta,

If your data on Worksheet1 is presently in Columns A2, B2 & C2, place this formula in Column D2 or E2 and copy down as far as you need.

=VLOOKUP($A2,Sheet2!$A$2:$B$100,2,FALSE)

Note: The Sheet2 name will have to be changed to the name of your Worksheet Two and the Range for column B will need to be extended to the bottom of your lookup list.

Hope that helps,

Dean

[Violeta]

I must be doing something wrong but it's not working... I will try to upload an excel file with sample data, but I'll zip it because it won't let me upload Excel files.

[ChemistB]

I put the vlookup formula into the third column in sheet 1 and dragged down. Table refers to the data on sheet 2. Simply highlight the whole range (in this case A2:B5, then in the name box (where it probably says A2 on the toolbar) type in Table.

Let us know if this works.

ChemistB