extracting data from one worksheet based on another - VLookup?
 

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.

extracting data from one worksheet based on another - VLookup?
 

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

I've explained it more clearly he

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

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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58320

extracting data from one worksheet based on another - VLookup?
 

That's a very nice solution!

--
Regards
Roger Govier

"JBeaucaire" wrote in message
...

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

I've explained it more clearly he

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

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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:
http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58320