Hi all. Need to generate a search engine that can extract data from multiple columns

[waqasnoor]

HI all.

I am working on a little task. i have a collection of over 800 movie names that have been sorted into their respective genres.
i need to be able to select 1-3 genres and it should show me all the movies that match the different genres selected.

eg. if i select action and war, it would show me movies like Fury, 300 etc. if i select romance, drama and comedy, it would pick something like 500 days and others and display them all.

how would this be possible?

Thanks

[tim201110]

autofilter