| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Data from another worksheet based on user input | Excel Worksheet Functions | |||
| Extracting data from one worksheet to another? | Excel Discussion (Misc queries) | |||
| Extracting data into another worksheet | Excel Discussion (Misc queries) | |||
| Extracting data from large worksheet | Excel Worksheet Functions | |||
| Extracting data based on content | Excel Discussion (Misc queries) | |||
Linear Mode
