extracting data from one worksheet based on another - VLookup?

D

des

I have a worksheet Sheet1 with a list of about 1,000 students and their
timetables. From this list I want to extract the data relating to a subset
of those students listed in Sheet2 (e.g. Honour Roll students).

The format of the original makes it difficult - maybe impossible - to use
VLookup. The original list uses multiple rows for each student, like this -

Nam1 Nam2 No. Per Subj Rm Teacher
Cho Ed 483729533 A Math 132 Karim
Cho Ed 483729533 B Eng 317 Wong
Cho Ed 483729533 C Geo 210 Smith
etc. for 9 rows for each student to cover all 9 periods of the day.

I can use VLookup to locate matches based on the student number, but it
works only for the FIRST match for each student number. In other words, I
can extract information about the first period (Per, Subj, Rm) but nothing
about the remaining 8.
 

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

Similar Threads

extracting data from one sheet based on data in another - VLookup? 3
Extracting specific rows out of one worksheet based on an identifi 1
linking data from one worksheet to another 1
Highlighting A Row Based on Cell Value Read from Another Document 2
need to extract data from a few worksheets to another 3
Import entire row of data to other worksheet based on one lookup v 4
Fill automatically from one worksheet to another based on cel valu 4
Transferring data from one worksheet to another based on criteria 5

Top