On Tue, 27 Oct 2009 09:16:16 +0530, "Ashish Mathur"
wrote:

As suggested by Tom, use advanced fitlers

You do not seem to understand. I am not filtering data in those
sheets. I am looking up data *from* those sheets to fill space in a
different sheet.

I enter the movie num in my main view panel (sheet) and all the single
lookup data pops in easily. I want to ad the actor's listing.

So, what I want is a simple one-to-many lookup list to appear on my main
sheet from data on the other sheets based on the movie number I enter.
All in the same workbook. I do not want to move over to another
worksheet and manually filter it, I want it to 'pop' in, just like the
simple, single value, one-to-one lookups do.