Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Report on data in rows & columns | Excel Discussion (Misc queries) | |||
pulling data in rows! | Excel Worksheet Functions | |||
Pulling data from multiple rows and columns | Excel Worksheet Functions | |||
excel 2003 having problems pulling top table from web query | Excel Programming | |||
Pulling data from a big report | Excel Discussion (Misc queries) |