searching rows for data from other sheet

[joed]

I need some guidance on what approach to take for this task.
I have one sheet with many rows of multiple cloum data. I have a 2nd sheet with 25 values. I want to search the 1st sheet for all rows containing any of the 25 values from second sheet and create a 3rd sheet with the row data found.
I have a medium knowledge of excel. If anyone could tell me
1. Is it possible to do this.
2. What appoach should I take.
I am willing to go out and use the help to learn new features. Please guide me in what I should be looking for.

 

[Asala42]

Hi joed,

Can you get away with using a series of Vlookups? Or are you hunting for a vba solution?

Adam

 

[joed]

I don't know what vlookups are. I am looking for what ever might work. I will spend some time checking what vlookups are and see if that will work.