Excel 2007 : find <cell reference> and copy to new sheet

**ngocpdn** · 07-22-2011, 05:15 AM

Hi all,

Thanks in advance,
I'm pretty new to excel, so forgive me.

I am looking for a formula that will search sheet 1 in column L for a word that is entered into sheet2A1 and copy the matching rows into sheet 2. A 2 and repeat until all of column L is checked.

Hope that makes sense.

Thanks again,
N

**Azam Ali** · 07-22-2011, 06:33 AM

in cell B2 of Sheet 2 copy this formula

=IFERROR(MATCH(A1,Sheet1!L:L,0),"")

and paste down

Kindly upload a sample workbook if problem is not solved

**ngocpdn** · 07-22-2011, 06:56 AM

Hi Azam Ali

i've attached a sample file.
is it possible to:
Search (SHEET 2!A1<NAME1!>) in SHEET 1 Column L and copy the rows with matching word into SHEET 2. I will use the same formula for the next sheet, but change the refernce text (NAME 2).

In the example file, on sheet 2 is the desire result.
However i have a 6months worth of data, so i am really hoping there is a formula that will work.

Thanks so much for helping