Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can VLOOKUP be used to search for more than one possible value?
I am trying to create an academic progress form for college students that is
specific to our department's requirements. We have different categories of classes that need to be completed: chemistry, biology, calculus, etc. Some of these are specific, e.g. Biology 171; for others, students have options, e.g. either Chemistry 151 or 161. We get a report on the courses students have completed each semester, which I put into a separate worksheet. I want the Excel form to automatically fill in course information in the appropriate category spaces based on course report data. I am attempting to use VLOOKUP to bring in specific data for the courses in these categories, but I'm stuck on this question. Q. How can I get Excel to look for more than one course that could fulfill a requirement, e.g. the chemistry requirement? I understand that if I sort my table by dept. name and then course number , then I can use VLOOKUP to get what I want. The table array reference would be specific to a single dept so that only its sorted course numbers would be included. I can then return at least the highest number course the student has taken by using a lookup value that is larger than any course number in the table. However, since this table will grow as courses are added over time, the table array reference will need to change each time data is added. Is this a more appropriate task for Access? I'm not familiar with how it works. Thanks, |
#2
|
|||
|
|||
Sounds like you could do better with either autofilter or advanced filter
-- Regards, Peo Sjoblom (No private emails please) "Travis" wrote in message ... I am trying to create an academic progress form for college students that is specific to our department's requirements. We have different categories of classes that need to be completed: chemistry, biology, calculus, etc. Some of these are specific, e.g. Biology 171; for others, students have options, e.g. either Chemistry 151 or 161. We get a report on the courses students have completed each semester, which I put into a separate worksheet. I want the Excel form to automatically fill in course information in the appropriate category spaces based on course report data. I am attempting to use VLOOKUP to bring in specific data for the courses in these categories, but I'm stuck on this question. Q. How can I get Excel to look for more than one course that could fulfill a requirement, e.g. the chemistry requirement? I understand that if I sort my table by dept. name and then course number , then I can use VLOOKUP to get what I want. The table array reference would be specific to a single dept so that only its sorted course numbers would be included. I can then return at least the highest number course the student has taken by using a lookup value that is larger than any course number in the table. However, since this table will grow as courses are added over time, the table array reference will need to change each time data is added. Is this a more appropriate task for Access? I'm not familiar with how it works. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
vlookup search for more then one answer | Excel Discussion (Misc queries) | |||
is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
can vlookup search multiple data tables | Excel Discussion (Misc queries) | |||
how to set up a vlookup table with 2 search terms? | Excel Worksheet Functions |