Problems Pulling Data from 2 Rows into a Report
 

Hi - I have a VLOOKUP that works to pull a row of student data from a
grade sheet into a report sheet. How can this be modified to pull 2
adjacent rows of student data onto the report sheet? In the
gradesheet (Period 1), student first and last names are in cols B and
C, and col A combines the names =IF(B13="", A12 & " B", B13 & ", " &
C13)

Each student's record occupies 2 adjacent rows.

================================================
' in the report sheet........code from Bernie

In worksheet "Period 1 Report", there is a cell named: StudName
Below this is a block of formulas:

=INDEX('Period 1'!$12:$12,1,Column(D1))
=VLOOKUP(StudName,'Period 1'!$13:$10000,COLUMN(D1),FALSE)
=VLOOKUP(StudName ___????___,'Period 1'!$13:$10000,COLUMN(D1),FALSE)

=================================================

Also, what teachers would like would be a cmd button on every other
student's row (col A) in the gradesheet that, when clicked, would copy
the combined student name into the StudName cell on the report sheet,
set the focus to the report sheet, and then update the VLOOKUP.

Any help would be very much appreciated.