Hello everybody,
I have a master list of books and course. each course has a course
number.for each course there are different number of books.the books are
linked to the course by the course number.
So in a new sheet when i enter the course number, for example 09001:
English, 10 books required,price all comes up without a problem. the problem
comes when i try to recall the book list. it cycles through and only prints
the last book in that section. i've been using the vlookup function.

Is there a way i can get excel to print out all the books by inputting the
course number. Do i group them together and recall the group? or do i have
to create many if/else like statements to start cycling through the list.

my brain is melting trying different formulas
thanks in advance.