extracting data from one worksheet based on another - VLookup?

[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.

 

[JBeaucaire]

I use a UDF called VLOOKUPS, a beefy version of VLOOKUP except i
returns a array of answers. It would pop out a list of all 9 classes fo
any student you selected

I've explained it more clearly here

'Excel Help Forum' (http://tinyurl.com/bahg77

If you post a message to JBeaucaire on that forum, I can send you
sample spreadsheet tailored to your data, it's pretty simple once yo
see it in action

 

[Roger Govier]

That's a very nice solution!