Problems Pulling Data from 2 Rows into a Report

6

6afraidbecause789

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top