searching rows for data from other sheet

joed · May 6th, 2002, 01:59 PM

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 · May 6th, 2002, 02:28 PM

Hi joed,

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

Adam

joed · May 7th, 2002, 06:35 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 01:59 PM	#1
joed New Member Join Date: May 2002 Posts: 48	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.

May 6th, 2002, 02:28 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hi joed, Can you get away with using a series of Vlookups? Or are you hunting for a vba solution? Adam

May 7th, 2002, 06:35 AM	#3
joed New Member Join Date: May 2002 Posts: 48	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.